Interested to Buy Any Domain ? << Click Here >> for more details...
Do joiner transformation use cache? If so describe?
- 2 Answers
- 7037 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 |
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
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 ?
can we use mapplet as starting n ending object in mapping
What are the uses of a Parameter file?
When to use normalization transformation other than cobol source?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
How to generate sequence numbers?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
What is source qualifier?
Teradata 
