Do joiner transformation use cache? If so describe?

Answer Posted / krish

Caching Master Rows
When the Integration Service processes a Joiner
transformation, it reads rows from both sources concurrently
and builds the index and data cache based on the master
rows. The Integration Service then performs the join based
on the detail source data and the cache data.
ur right buddy

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How an expression transformation differs from aggregator transformation?

628


How to join three sources using joiner? Explain though mapping flow.

702


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2299


How can informatica be used for an organization?

653


Write the unconnected lookup syntax and how to return more than one column.

599






write a query to retrieve the latest records from the table sorted by version(scd)

635


Is it possible to revert a global repository to local one and why?

615


What do you understand by term role-playing dimension?

580


How to load a Dimension ? and how to load a fact table?

957


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

552


Whats the difference between informatica powercenter server, repositoryserver and repository?

679


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

1466


Explain how many types of dimensions are available in informatica?

595


What are the differences between joiner transformation and source qualifier transformation?

628


What are the restrictions of union transformation?

581