| |
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.
|
| January 01, 2006 00:59:06 |
#4 |
| Sithu |
Database Expert Member Since: December 2005 Total Comments: 161 |
RE: what is the look up transformation?
|
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. Cheers, Sithu |
| |
Back To Question | |
