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

Answer Posted / basha

based on the situation if we need to cache concept we will
use lkp tr ,we doesnot need to caches we use joiner tr
performence wise joiner is better

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1412


without table how to come first record only in oracle?

1861


What is a transaction control transformation?

768


Enlist some properties of sessions.

636


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640






What are the components of workflow manager?

590


r u done any partitions in ur project?

1407


How to load the data from a flat file into the target where the source flat file name changes daily?

582


Briefly define a session task?

595


Mention few power centre client applications with their basic purpose?

540


Explain dynamic target flat file name generation in informatica

652


When do you use sql override in a lookup transformation?

591


How to create the list file having millions of flat files while indirect loading in informatica? 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?

1470


Explain your project of banking domian.

1220


 Informatica Checkpoints

2859