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

Can u generate reports in Informatica?

658


Differentiate between source qualifier and filter transformation?

1003


Explain the features of connected and unconnected lookup.

548


How to Create a folder using pmrep command?

626


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

555






Design a mapping to load the cumulative sum of salaries of employees into target table?

900


Does an informatica transformation support only aggregate expressions?

608


can u give example for factless fact table

5527


Enlist the advantages of informatica.

632


How does the aggregator transformation handle null values?

702


What is main use of mapplet?

662


What is the use of an aggregator cache file?

692


Explain the difference between mapping parameter and mapping variable?

606


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

700


tell me the rules and responsblites in our project(my project is development)

1502