Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What are the joiner caches?

asked marvit September 20, 2014 08:02 AM  

What are the joiner caches?


1 Answers

answered By Mswami   0  
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 performs joins.

Joiner cache have 2 types of cache:

1.Index cache
2.Data cache.

Index cache stores all the port values which are participated in the join condition and Data cache have stored all ports which are not participated in the join condition.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!