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 the informatica performance improvement tips
What is rank transform?
what is the difference between informatica6.1 and infomatica7.1
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is meant by query override?
Does an informatica transformation support only aggregate expressions?
How many dimensions are there in informatica?
What is event and what are the tasks related to it?
How to extract sap data using informatica?
Differentiate between reusable transformation and mapplet.
Explain how many types of dimensions are available in informatica?
lookup transformation with screenshots
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different lookup cache(s)?