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

More Informatica Interview Questions

How to load relational source into file target?

3 Answers IBM,

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers Oracle,

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers Wipro,

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers TCS,

Differences between version 7.x and 8.x.

0 Answers Accenture, Cognizant,

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers Altisource, TCS,

What is expression transformation?

0 Answers

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers Hexaware,

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers TCS,

what is junk dimension

4 Answers Cap Gemini,

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers

For more Informatica Interview Questions Click Here