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.
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
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 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
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
No comments:
Post a Comment