Lookup works as Master outer Join in informatica .. Oracle--> its wor

Hi,
Lookup() is what kind of join ?

Question Posted / sunil

Answer Posted / sunil

Lookup works as Master outer Join in informatica ..

Oracle--> its works as left outer join..

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the key challenges that you face while performing etl testing.

1059

When do we analyze the tables?

1017

what is Forward,Reverse and Re_engineering?

2312

what are the reports developed in sap bw project and what is the requirement for developing it?

2229

What is partitioning? Explain about round-robin, hash partitioning.

1024

explain the methodology of Data Warehousing?(Polaries)

2365

what is pmrep command?

2483

what is session partitioning?

2199

what is the difference between cubes and package in cognos

5001

Compare etl & elt?

1055

Identifying the bottlenecks in various components of Informatica and resolving them.

1981

how does the server recongnise the source and target databases.Elaborate on this

2740

how do u set partition points in the mapping?

2301

how would u estimate the size of Lookup transform data and index cache?

2192

what is the meant by Normalization and de-normalization?

2766