Interested to Buy Any Domain ? << Click Here >> for more details...
What is joiner cache?
- 2 Answers
- 6610 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 |
Using Expression transformation how to remove duplicate records from a relational source?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
Differentiate between joiner and lookup transformation?
When the informatica server marks that a batch is failed?
What are Dimensions and various types of Dimensions?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Differentiate between a repository server and a powerhouse?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
What does cheating measurement mean?
What is Collect performance data in informatica and what is the use of it.
Explain pushdown optimization and types in informatica
Teradata 
