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



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

Answer / abhinaw prakash

There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is plsql table?

2 Answers  


what is fact table?

9 Answers  


what is the look up transformation?

2 Answers   Informatica,


How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,


can we generate reports in informatica ? How?

3 Answers  






What is intricate mapping?

0 Answers  


difference between stop and abort

2 Answers  


I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,


can you use flat file for lookup table?why?

2 Answers   HCL,


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


What is hash partition?

2 Answers  


Can you access a repository created in previous version of Informatica?

1 Answers  


Categories