What are the joiner caches?
Answers were Sorted based on User's Feedback
Answer / swetha
When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / atiric sofrware(raja)
joiner caches are data cache and index cache data cache.
data cache that holds the master table rows and the index
cache which holds the join columns from the master table
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / soujanya
the joiner transformation creates join cache for master
source. from joiner cache the the joiner transformation
compares with detail source.
the joiner cache always uses master source for better
performance bcoz master source has less no. of records.
cache is the temporary memory
Is This Answer Correct ? | 5 Yes | 0 No |
Explain what are the different versions of informatica?
when we go for unconnected lookup transformation? and why?
what are the transformations that restricts the partitioning of sessions?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
lookup transformation with screenshots
How can we update a record in the target table without using update strategy?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
What is complex mapping?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
whatis the default data driven operation in informatica
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?