What is joiner cache?

Answer Posted / chandrasekar

When we use the joiner transformation an integration service
maintains the cache, all the records are stored in joiner
cache. Joiner cache have 2 types of cache 1.Index cache 2.
Joiner 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.

If it wrong means Please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update or delete the rows in a target, which do not have key fields?

761


What are the differences between oltp and olap?

630


What is dimensional table? Explain the different dimensions.

768


What do you understand by SOA of Informatica?

668


How to Create a folder using pmrep command?

712






Difference between Target-based loading and constraint-based loading?

646


How do we call shell scripts from informatica?

665


Can you generate sequence numbers without using the sequence generator transformation?

672


How to generate sequence numbers without using the sequence generator transformation?

750


Differentiate between sessions and batches?

659


What is the session task and command task?

690


How we can use union transformation?

696


How to load the data from people soft hrm to people soft erm using informatica?

649


Is it possible to define a single node as a Gateway node as well as worker node?

763


what is informatica metadata?

692