Lookup Transformation in Informatica , is a connected/Unconnected 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. The Lookup transformation returns the result of the lookup to the target or another transformation . Example : you may lookup transformation on DEPT tables to get DEPT details based on DEPTNO as input port.
Must check : Please also check how to create Aggregator Transformation
Connected Lookup Transformation:
A very well explained example of Connected lookup transformation can be found here
Unconnected Lookup Transformation:
A very well explained example of UnConnected lookup transformation can be found here
Normally source of Lookup is either files or relational database, See here for explaination
To improve the performance of lookup transformation , we will need to enable the cache , see here for different type of cache lookup transformation. There are other guideline also given to improve the performance. A good article can be found here
Also check here to see the difference between Static cache and Dynamic Cache :
http://www.tecktricks.com/difference-between-static-cache-and-dynamic-cache-in-informatica/
No comments:
Post a Comment