Interested to Buy Any Domain ? << Click Here >> for more details...
Do joiner transformation use cache? If so describe?
- 2 Answers
- 6941 Views
- Patni, I also Faced
- E-Mail Answers
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 |
Explain the use of aggregator cache file?
Differences between connected and unconnected lookup?
What is a snowflake schema?
what is lookup ?
How many ways are there to do 'remove duplicate records in informatica'?
How does the aggregator transformation handle null values?
Enlist the advantages of informatica.
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
scd methodology?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Teradata 
