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


Why we select the table which has minimum number of records
as Master table in joiner?

Answers were Sorted based on User's Feedback



Why we select the table which has minimum number of records as Master table in joiner?..

Answer / balaswamy

because all rows from the master table are loaded into the cache,so that it will take up the least amount of space in the
cache

Is This Answer Correct ?    15 Yes 0 No

Why we select the table which has minimum number of records as Master table in joiner?..

Answer / ankit kansal

Its preferable to create your smaller table to be master because
1.Size issue Informatica will create index and data cache.
2.More logical lets say your master table contains 10 rows and your detailed table contains 1000 rows so each of your source rows just have to check against 10 of master rows and thus its faster wile if you take it viceversa than each of your source table hast to go against 1000 rows and it ll hot performance issue This is just a small example check with real scenario and you ll came to know.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    7 Yes 0 No

Why we select the table which has minimum number of records as Master table in joiner?..

Answer / voma

faster perfomance of loading

Is This Answer Correct ?    3 Yes 2 No

Why we select the table which has minimum number of records as Master table in joiner?..

Answer / moorthy g

The Integration Service(IS) reads data from master table
and build data cahe and data index for building cache.
After that read data from detail table perform joins. bcz
routine will be very less(master means very less record
compared to detail table).
Finaly time saving. performance incresing.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,


what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,


What is power play plug in?

2 Answers  


What is target load order?

0 Answers  


what is diff between grep and find

3 Answers   IBM, iFlex,


What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,


How big was your fact table

0 Answers  


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


Why do we use DSS database for OLAP tools?

2 Answers  


Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

2 Answers   CTS,


How to recover sessions in concurrent batches?

1 Answers  


Categories