What are the joiner caches?

Answer Posted / swetha

When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

list out all the transformations which use cache?

693


How to extract sap data using informatica?

608


What is flashback table ? Advance thanks

1484


What are the limitations of joiner transformation?

657


What is olap (on-line analytical processing?

647






How can we create index after completion of load process?

600


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4318


What is Session and Batches?

666


Explain the different dimensions.

558


tell me about your project functionality

1870


Why is sorter an active transformation?

667


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1535


Which transformation should we use to normalise the COBOL and relational sources?

748


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1753


How can you define user defied event?

624