Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhishek
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.
The number of rows the Integration Service stores in the cache depends on the partitioning scheme, the source data, and whether you configure the Joiner transformation for sorted input.
To improve performance for an unsorted Joiner transformation, use the source with fewer rows as the master source. To improve performance for a sorted Joiner transformation, use the source with fewer duplicate key values as the master.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is stop and abort are same in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
What do you mean by worklet?
Target increases every day even though no new record was inserted
What is mapplet in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the modules in Power Center
What are the static cache and dynamic cache in informatica?
what are the deliverables?in your project?
What is a rank transform?
What is the commit type if you have a transaction control transformation in the mapping?
To import the flat file definition into the designer where should the flat file be placed?
Tell me about Propagate functions in informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
