Connected Lookup vs Unconnected Lookup in Informatica

Connected Lookup and Unconnected Lookup are two types of lookups in Informatica that are used to retrieve data from a reference table based on a condition. Here are the key differences:

Connected Lookup

Connected Lookup is directly connected to the mapping pipeline and is used to return multiple columns from the reference table. It is easy to configure and maintain as it is part of the mapping flow.

Unconnected Lookup

Unconnected Lookup is not directly connected to the mapping pipeline and is called within an expression or another transformation. It is used to return a single value from the reference table and can be re-used across multiple mappings.

Understanding the difference between Connected Lookup and Unconnected Lookup is essential for designing efficient mappings in Informatica.