| |
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 09:43:49 |
#3 |
| an ETL guy |
Member Since: Visitor Total Comments: N/A |
RE: what is the look up transformation?
|
| 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 |
| |
Back To Question | |
