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 |
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
how many ways can we implement SCD2?
wf dont have integration severances how you can run?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What are the uses of etl tools?
What is expression transformation?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
I have 1200 records how can u send it in aggregator with good performance issues?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What are the components of Informatica? And what is the purpose of each?
What is a joiner transformation and why it is an active one?