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

What is union transformation in informatica?

695


What do you mean incremental aggregation?

621


What is a snowflake schema?

563


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3317


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2423






What is a joiner transformation and why it is an active one?

573


What do you understand by a term domain?

666


How do you migrate data from one environment to another?

639


How might one distinguish in the case of mapping is right or not without associating session?

636


How many dimensions are there in informatica?

623


Is there any way to read the ms excel datas directly into informatica?

546


What is a passive transformation?

636


What is primary and backup node?

692


What are the differences between oltp and olap?

546


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462