How do you create single lookup transformation using
multiple tables?
Answer Posted / latha
Lookup transformation: Based upon one/more keys the data is
retreived from one/more tables.
create a single lookup transformation by Joining the
multiple tables, having connected the keys defined in
lookup tranformation.
| Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
What is a joiner transformation?
How to generate sequence numbers?
How do you take back up of repository?
Differentiate between a database and data warehouse?
Explain what is informatica metadata and where is it stored?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Design a mapping to load a target table with the following values from the above source?
What is primary and backup node?
Explain direct and indirect flat file loading (source file type) - informatica
What does refresh system mean, and what are its distinctive choice?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Mention few power centre client applications with their basic purpose?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is joiner change?