- 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
Check here for Difference between connected and unconnected lookup transformation
3. Based on Cached Type
- Cached Lookup Transformation
- UnCached Lookup Transformation
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