Use lookup transformation in u’r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table column values based on the look up condition.
Using it we can access the data from a relational table which is not a source in the mapping.
For Ex:Suppose the source contains only Empno, but we want Empname also in the mapping.Then instead of adding another tbl which contains Empname as a source ,we can Lkp the table and get the Empname in target.
A lookup is a simple, single-level reference structure with no parent/child relationships. Use a lookup when you have a set of reference members that you do not need to organize hierarchically.
In DecisionStream, a lookup is a simple, single-level reference structure with no parent/child relationships. Use a lookup when you have a set of reference members that you do not need to organize hierarchically.HTH
Use a Lookup transformation in your mapping to look up data in a relational table, view, or synonym. Import a lookup definition from any relational database to which both the Informatica Client and Server can connect. You can use multiple Lookup transformations in a mapping.
Lookup transformation in a mapping is used to look up data in a flat file or a relational table, view, or synonym. You can import a lookup definition from any flat file or relational database to which both the PowerCenter Client and Server can connect. You can use multiple Lookup transformations in a mapping.
