Answer Posted / swetha
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
Difference between Data and Index Caches?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a mapplet/worklet in informatica?
Tell me about Propagate functions in informatica
Whats there in global repository
What is parallel processing in informatica?
How to load a Dimension ? and how to load a fact table?
In informatics server which files are created during the session rums?
complex mapping ur project u r invlve can u explain and give real time example give me ?
tell me about your project functionality
Differentiate between Load Manager and DTM?
What are the modules in Power Center
What is the fact table?
What are the issues you have faced in your project? How did you overcome those issues?