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

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  


Explain why we use partitioning the session in informatica?

0 Answers  


source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,


Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,


what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


How might you approve all mappings in the archive all the while?

0 Answers  


Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,


SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  


How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  


What is fact table? Explain the different kinds of facts.

0 Answers  


Categories