On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?
Answer Posted / pradeep
We wil go for left outer join on the lookup table in the
source qualifier sql override so that it wil return both the
records.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
Could you explain what is enterprise data warehouse?
Explain sessions. Explain how batches are used to combine executions?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Can informatica load heterogeneous targets from heterogeneous sources?
What is a surrogate key?
What is Index Caches size?
can anyone explain me about retail domain project in informatica?
Define mapping and session?
What is lookup transformation?
What is meant by lookup transformation?
How can informatica be used for an organization?
How can we store previous session logs?
What differs when we choose the sorted input for aggregator transformation?
How can we improve session performance in aggregator transformation?