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 |
What is the difference between sequential batch and concurrent batch and which is recommended and why?
what is constraint based load order
how to create user defined function (udf) in informatica
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
what are the real time problems generally come up while doing or running mapping or any transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to delete first 3 rows & last 3 rows in target table in informatica
can we use mapplet as starting n ending object in mapping
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
In joiner, how to load Master table in Target?
How can you define user defied event?