which is better perfomancewise lookup or joiner and why?can anyone give example?

Answer Posted / m.m.basha

performwise both (connected& unconnected) are best
connected lookup :-it is connected to the source
unconnected loockup:- it is not connected to the source

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

update strategy transformation in informatica

641


Sequence generator, when you move from develoment to production how will you reset

1404


Mention few advantages of router transformation over filter transformation.

633


What is joiner transformation in informatica?

625


wf dont have integration severances how you can run?

1539






What do you understand by a term domain?

668


explain one complex mapping with logic? sales project?

6148


How many input parameters can exist in an unconnected lookup?

990


What is workflow? What are the components of the workflow manager?

638


Define pmcmd command?

618


what is the hint? how to use it to reduce the query processing in program?

6296


Explain pushdown optimization $pushdownconfig parameter - informatica

700


What are session parameters ? How do you set them?

1375


What are the mapping parameters and mapping variables?

622


What is domain and gateway node?

692