Interested to Buy Any Domain ? << Click Here >> for more details...
What is joiner cache?
- 2 Answers
- 6564 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 |
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is data movement mode in Informatica and difference between them?
How can we store previous session logs?
How i can upload the MainFrame source For Informatica ?
What r the type of indexes u generally used in informatica?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
what is the dashbords?
how eliminate the duplicates in flat file with out using sorter ,aggregater
What is meant by pre and post session shell command?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
Why should we use star schema in datawarehouse design?
Teradata 
