Do joiner transformation use cache? If so describe?

Answer Posted / mike

Yes joiner transformation has cahches. It joins the data
based on master detail joining condition. It first reads
the master source and stores it in the joiner cache and it
reads the detail source and joins with the data in the
joiner cache based on the master detail joining condition.

correct me if i was wrong

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are some examples of informatica etl programs?

540


What can we do to improve the performance of informatica aggregator transformation?

620


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5261


What are the types of presistent cache in look up tr.

1551


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1587






How to call shell scripts from informatica?

577


What are the settings that you use to configure the joiner transformation?

615


How to create or import flat file definition in to the warehouse designer?

618


What is the use of code page?

610


How to handle decimal places while importing a flatfile into informatica?

727


Differentiate between joiner and lookup transformation?

618


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


Please let me know how to make Data masking in informatica..

1271


How can you increase the performance in joiner transformation?

712


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1856