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

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  


How to differentiate between the active and passive transformations?

0 Answers  


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  


difference between repository database and repository service?

0 Answers  






how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,


What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  


Does Facttable Normalized or Denormalized?

2 Answers   IBM,


Performance tuning( what you did in performance tuning)

0 Answers   Infosys,


in which situations do u go for scds ?

3 Answers   TCS,


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


Categories