Do joiner transformation use cache? If so describe?
Answers were Sorted based on User's Feedback
Answer / mike
Yes joiner transformation has cahches. It joins the data
based on master detail joining condition. It first reads
the master source and stores it in the joiner cache and it
reads the detail source and joins with the data in the
joiner cache based on the master detail joining condition.
correct me if i was wrong
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / krish
Caching Master Rows
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.
ur right buddy
| Is This Answer Correct ? | 2 Yes | 0 No |
when informatica 8 series released ?
what is row level and column level indicator?
What are the reusable transformations?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
how to load rows into fact table in data warehouse
what is the size of your data warehousing?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
i have two source data there is no pk,fk how to join the two sources
Enlist the tasks for which source qualifier transformation is used.
What is facttable granularity?
waht type of interface is used for testing the data in informatica
What is the meaning of up gradation of repository?