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
What is the meaning of up gradation of repository?
What is dimensional table?
Which development components of informatica have the highest usage?
What is informatica powercenter repository?
How to partition the Session?
what is the size of your data warehousing?
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?
What is workflow monitor?
can anyone suggest best free Talend data integration training online
Separate from an archive server and a powerhouse?
What is the use of code page?
Why is sorter an active transformation?
COM components can be used in Informatica
Clarify the utilization of aggregator cache record?
Is there any target staging area in informatica not staging area