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 |
how to work with mapplet designer in informatica?
How would you copy the content of one repository to another repository?
What are the differences between joiner transformation and source qualifier transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Parameter and variable differences
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
What is an MDDB? What is the difference between MDDBs and RDBMSs?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?