Interested to Buy Any Domain ? << Click Here >> for more details...
What is joiner cache?
- 2 Answers
- 6698 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
What is the functionality of update strategy?
how will compare two mappings in two different repository?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What is the difference between sequential batch and concurrent batch and which is recommended and why?
What are the different options available for update strategy?
How to call shell scripts from informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the joiner caches?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Do you find any difficulty while working with flat files as source and target?
What is the meaning of up gradation of repository?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
Teradata 
