Lookup Transformation vs Joiner Transformation in Informatica

Lookup and Joiner transformations are commonly used in Informatica to join data from different sources or tables. Here is the key difference between the two:

Lookup Transformation:

The Lookup Transformation is used to look up data in a relational database table or a flat file. It searches for a match in the lookup table and returns the corresponding value. The lookup condition can be based on one or more columns.

Key Features of Lookup Transformation:

• Used to retrieve data from a lookup table
• Supports dynamic lookup, which allows you to change lookup conditions at runtime
• Can perform various types of lookup operations like Normal, Connected, and Unconnected lookups

Joiner Transformation:

The Joiner Transformation is used to join data from two heterogeneous sources based on a condition. It combines rows from different sources into a single row output. Joiner Transformation can perform Outer, Full Outer, and Left Outer joins.

Key Features of Joiner Transformation:

• Joins data from two different sources
• Supports different types of joins like Inner, Outer, and Full Outer joins
• Combines data based on the specified join condition

In summary, while Lookup Transformation is used for looking up data in a table or file, Joiner Transformation is used to combine data from different sources based on a specified condition.