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


Please Help Members By Posting Answers For Below Questions

What does update strategy mean, and what are the different option of it?

865


Could you explain what is enterprise data warehouse?

784


Explain sessions. Explain how batches are used to combine executions?

805


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

6920


Can informatica load heterogeneous targets from heterogeneous sources?

961


What is a surrogate key?

838


What is Index Caches size?

870


can anyone explain me about retail domain project in informatica?

7731


Define mapping and session?

802


What is lookup transformation?

841


What is meant by lookup transformation?

815


How can informatica be used for an organization?

920


How can we store previous session logs?

804


What differs when we choose the sorted input for aggregator transformation?

823


How can we improve session performance in aggregator transformation?

910