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
Sequence generator, when you move from develoment to production how will you reset
without table how to come first record only in oracle?
What is a transaction control transformation?
Enlist some properties of sessions.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the components of workflow manager?
r u done any partitions in ur project?
How to load the data from a flat file into the target where the source flat file name changes daily?
Briefly define a session task?
Mention few power centre client applications with their basic purpose?
Explain dynamic target flat file name generation in informatica
When do you use sql override in a lookup transformation?
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?
Explain your project of banking domian.
Informatica Checkpoints