Lookup Transformation
The Lookup transformation retrieves data from a lookup object based on the specified lookup condition. For example, you can use a Lookup transformation to retrieve the values for codes used in source data.
The Lookup transformation includes the following lookup properties:
- •Lookup object. The connection and object to use, as well as multiple match behavior.
- •Lookup condition. The condition that returns lookup values.
- •Return fields. Return fields from the lookup object.
- •Advanced properties. Caching and other options.
You can perform a lookup on files, database tables, Salesforce, SAP tables, and on other data sources using an Informatica toolkit connector.