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
Define update strategy?
How can you define user defied event?
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?
Can you generate sequence numbers without using the sequence generator transformation?
What is the benefit of session partitioning?
What is a repository? And how to add it in an informatica client?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain the features of connected and unconnected lookup.
What is informatica metadata and where is it stored?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How many transformations can be used in mapplets.
Define joiner transformation?
What is a predefined event?
In development project what is the process to follow for an etl developer from day1
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me