performance wise which one is better in joiner and lookup transformation?why?explain clearly?



performance wise which one is better in joiner and lookup transformation?why?explain clearly?..

Answer / venubyna1

Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  


What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,


Differentiate between sessions and batches?

0 Answers  


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,






In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  


in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


How can we eliminate duplicate rows from flatfile,explain?

3 Answers  


How to compare Source and Target table, without using dynamic lookup?

4 Answers  


what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,


Categories