| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: what is the look up transformation?
Answer: 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.
|
| December 12, 2005 00:06:38 |
#1 |
| phani |
Member Since: Visitor Total Comments: N/A |
RE: what is the look up transformation?
|
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. |
| |
Back To Question | |
