Yes, we can use Lookup to join 2 tables. Lookup performs Left Outer Join

Can we use Lookup instead of Joiner to join 2 tables?
If yes which is faster and why?

Question Posted / zak

Answer Posted / zak

Yes, we can use Lookup to join 2 tables. Lookup performs
Left Outer Join by default.

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the size of u r source(like file or table)?

2254

Can we override a native sql query within informatica?

1025

What is the session task and command task?

1035

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2058

What are the informatica performance improvement tips

1071

What is target load order?

1230

what is unit testing?tell me proceedure

2206

How do you change a non-reusable transformation to reusable transformation?

987

What are mapplets? How is it different from a Reusable Transformation?

1075

What are the types of schemas we have in data warehouse.

947

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5764

How can we use mapping variables in informatica?

1042

can u any challenge your project?

2020

What are the different lookup cache(s)?

1100

What are the types of lookup transformation?

1061