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
Why update strategy and union transformations are active? Explain with examples.
Differences between connected and unconnected lookup?
where to store informatica rejected data? How to extract the informatica rejected data?
What is union transformation in informatica?
What are ETL Tools?
What is confirmed fact in dataware housing?
What is target load order?
what is degenerated dimension?
Can we create multiple integration service on single repository?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Make a note of the quantity vaults made in informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain lookup transformation is active in informatica
Is it possible to use a client with different version than that of its Informatica server?