We wil go for left outer join on the lookup table in the source qualifier

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?

Question Posted / pradeep

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

Please Help Members By Posting Answers For Below Questions

What is target designer and target load order?

743

What is the difference between router and filter?

721

Is it possible to create multiple domains on a single Informatica server?

866

my source is junk data how will u remove that junk data by using unix please any one replay me

3354

Explain the shared cache and re-cache?

704

What is transformation?

764

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

900

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

904

What are the different versions of informatica?

796

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2382

complex mapping ur project u r invlve can u explain and give real time example give me ?

1952

What are the measure objects?

770

What is meant by lookup transformation?

695

What is target load order?

898

What is rank transformation in informatica

799