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

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445

What is a sequence generator transformation?

1075

How would you copy the content of one repository to another repository?

1058

What is the Rank index port in Rank transformation?

1102

How to handle decimal places while importing a flatfile into informatica?

1242

list out all the transformations which use cache?

1242

r u done any partitions in ur project?

1866

what is Active lock explain

2858

Explain how many types of dimensions are available in informatica?

1172

which one is better performance wise joiner or look up

1151

What are the differences between joiner transformation and source qualifier transformation?

1238

Performance tuning in UNIX for informatica mappings?

2625

what is the difference between informatica6.1 and infomatica7.1

2361

explain abt ur project architecture?

2235

What is powercenter on grid?

1228