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

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

Question Posted / s198

4 Answers
19937 Views
HG, UST, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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