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

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

Question Posted / zak

2 Answers
9664 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / sunil

Joiner is faster than lookup. because by default lookup writes order by clause on every column connected to that transformation which decreses the performance..so joiner is faster than lookup..

If anything wrong pls let me know...am looking for job..

Is This Answer Correct ?

5 Yes

1 No

Post New Answer

More Informatica Interview Questions

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers Polaris,

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers Wipro,

lookup transformation with screenshots

0 Answers TCS,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers Cap Gemini,

why union transformation is active transformation?

6 Answers IndiGo, TCS,

What is aggregate awareness?

1 Answers

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers Logica CMG,

What are the new features in Informatica 5.0?

1 Answers

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers CTS,

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers Emphasis,

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers TCS,

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers HP,

For more Informatica Interview Questions Click Here