Do joiner transformation use cache? If so describe?
Answer Posted / krish
Caching Master Rows
When the Integration Service processes a Joiner
transformation, it reads rows from both sources concurrently
and builds the index and data cache based on the master
rows. The Integration Service then performs the join based
on the detail source data and the cache data.
ur right buddy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
how many types of dimensions are available in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Why is sorter an active transformation?
what is unit testing?tell me proceedure
How you know when to use a static cache and dynamic cache in lookup transformation?
generate date / time dimension in informatica
How do you change a non-reusable transformation to reusable transformation?
What is data movement mode in Informatica and difference between them?
What is data caches/ index caches?
How would you copy the content of one repository to another repository?
What is rank index in rank transformation?
What are the informatica performance improvement tips
What are the differences between joiner transformation and source qualifier transformation?