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


What are the joiner caches?

Answers were Sorted based on User's Feedback



What are the joiner caches?..

Answer / swetha

When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.

Is This Answer Correct ?    16 Yes 1 No

What are the joiner caches?..

Answer / atiric sofrware(raja)

joiner caches are data cache and index cache data cache.

data cache that holds the master table rows and the index
cache which holds the join columns from the master table

Is This Answer Correct ?    11 Yes 0 No

What are the joiner caches?..

Answer / soujanya

the joiner transformation creates join cache for master
source. from joiner cache the the joiner transformation
compares with detail source.
the joiner cache always uses master source for better
performance bcoz master source has less no. of records.
cache is the temporary memory

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  


how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,


What is a unit Testing?

1 Answers  


Mention some types of transformation?

0 Answers  


How do you change a non-reusable transformation to reusable transformation?

0 Answers  


How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,


Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  


Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


Describe two levels in which update strategy transformation sets?

1 Answers  


What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,


I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,


Categories