Lookup Transformation in Informatica with Example

Lookup Transformation in Informatica , is a connected/Unconnected and Passive (post 9 Active and Passive transformation) which let you look up data flat file/relation tables ,views or synonym.The Integration Service queries the lookup source based on the lookup ports in the transformation and a lookup condition. Lookup transformation returns the result of the lookup to the target or another transformation.

Informatica scenarios of Lookup Transformation

You can use lookup Transformation in mapping for below type of tasks:

• Getting  related value:  Retrieve value from the lookup table based on a value in the source. For example, the source has an employee ID. Retrieve the employee name from the lookup table.
• Perform a calculation: Retrieve a value from a lookup table and use it in a calculation. For example, retrieve  a sales tax percentage, calculate a tax, and return the tax to a target.
• Update slowly changing dimension tables: Determine whether rows exist in a target  and accordingly you can create  a new record or update the existing one.

Types of Lookup Transformation in Informatica:

A. Based on the Source Type:

• Flat File Lookup Transformation
• Relational Lookup  Transformation

Check here for Relational vs flat file lookup transformation in informatica

B. Based on Connection Type:

connected Lookup transformation 

Unconnected Lookup Transformation

unconnected lookup transformation part 2

unconnected lookup transformation part 1

Check here for Difference between connected and unconnected lookup transformation

3. Based on Cached Type

• Cached Lookup Transformation
• UnCached Lookup Transformation

You can keep Lookup Transformation as uncached by unchecking the Cache option in properties tab.

 

Check here for Properties of lookup transformation in informatica

Example  of Lookup Transformation :

Check here for Connected lookup transformation in informatica

Check here for Unconnected lookup transformation in informatica

Incoming Search Terms :-

lookup transformation properties

lookup transformation in informatica with example
lookup transformation in informatica interview questions
how to implement lookup transformation in informatica
lookup transformation in informatica tutorial
lookup transformation in informatica pdf
dynamic lookup transformation in informatica
lookup transformation in informatica ppt