Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Do joiner transformation use cache? If so describe?

Answers were Sorted based on User's Feedback



Do joiner transformation use cache? If so describe?..

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

Do joiner transformation use cache? If so describe?..

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

Post New Answer

More Informatica Interview Questions

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,


what is data driven?

5 Answers   TCS, Wipro,


What is aggregate cache in aggregator transformation?

0 Answers   Informatica,


I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,


what is the diff b/w union and joiner and lookup?

4 Answers  


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  


Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,


Define filter transformation?

0 Answers  


what is distinct

4 Answers  


In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  


Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,


What is the difference between a table and the materialized view?

2 Answers  


Categories