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

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1080

What is parallel processing in informatica?

1710

How to elaborate tracing level?

1171

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

1280

What is domain and gateway node?

1162

What is a mapplet/worklet in informatica?

1185

What do you mean by enterprise data warehousing?

1063

update strategy transformation in informatica

1064

What is session task and command task?

1288

What happens when a session fails and you click on recover?

1116

How do you migrate data from one environment to another?

1092

Clarify the utilization of aggregator cache record?

994

Explain the different lookup methods used in informatica?

1038

What is informatica powercenter repository?

1198

How to load the data from a flat file into the target where the source flat file name changes daily?

1051