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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Do joiner transformation use cache? If so describe?

Question Posted / mike

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

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

What is joiner cache?

2 Answers   TCS,

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

What are the types of caches in lookup? Explain them.

0 Answers  

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

How to call shell scripts from informatica?

0 Answers  

How to open an older version of an object in the workspace?

0 Answers  

what we require for D.modelling?

1 Answers  

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

For more Informatica Interview Questions Click Here
Categories