Data Lookup generates a lookup based on data provided during the transformation process. The component has two input ports: one for the incoming data records and a second port for the lookup data.
Use Data Lookup when your lookup data cannot be retrieved directly from a database, but can be provided by the transformation process. For example, you may want to use this procedure when data is located in a text file.
