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
Can you generate sequence numbers without using the sequence generator transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the surrogate key?
What is different between the data warehouse and data mart?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can we create index after completion of load process?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Could you explain what is enterprise data warehouse?
What is the Rank index port in Rank transformation?
Please let me know how to make Data masking in informatica..
What is a connected transformation?
What the difference is between a database, a data warehouse and a data mart?
What is substr in informatica?
where to store informatica rejected data?
How many ways are there to do 'remove duplicate records in informatica'?