Transformations > Lookup Transformation
  

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:
You can perform a lookup on files, database tables, Salesforce, SAP tables, and on other data sources using an Informatica toolkit connector.