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 to configure mapping in informatica?

1 Answers  


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,


What is meant by a domain?

1 Answers  


In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,


what is unit testing?tell me proceedure

1 Answers   L&T, UST,


How to display First letter of Names in Caps?

7 Answers  


Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1 Answers   SeeInfoBiz, TCS,


How might you approve all mappings in the archive all the while?

1 Answers  


What is predefined event?

1 Answers  


Write the different tools in the workflow manager?

1 Answers  


complex mapping ur project u r invlve can u explain and give real time example give me ?

1 Answers   HGS, TCS,


Categories