Informatica - Joiner Transformation Master Detail

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 600 of 644

Joiner Transformation Master Detail

Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

Total Answers and Comments: 5

Last Update: January 14, 2009 Asked by: sarun5

Sponsored Links

Best Rated Answer

—

Submitted by: Sreeya

We will consider the one with lesser number of records as master as with this approach the data to be cached would have to be less and hence the performance can be improved.

Above answer was rated as good by the following members:
hasim_geek, jmamxd, avneeshrathor

February 19, 2008 07:47:57

ABHIDHAN

Member Since: October 2007 Contribution: 4

RE: Joiner Transformation Master Detail

the table contains the less no of records always being used as master detail to improve the performance....

Is this answer useful? Yes | No

February 19, 2008 16:14:22

Sreeya

Member Since: February 2008 Contribution: 3

RE: Joiner Transformation Master Detail

We will consider the one with lesser number of records as master as with this approach the data to be cached would have to be less and hence the performance can be improved.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 08, 2008 14:57:02

franticsky

Member Since: May 2008 Contribution: 2

RE: Joiner Transformation Master Detail

In order to boost performance always choose the tabel with lesser rows to be the master table

Is this answer useful? Yes | No

August 15, 2008 13:57:49

ghola

Member Since: July 2008 Contribution: 1

RE: Joiner Transformation Master Detail

The joiner transformation compares each row of the master source against the detail source. Hence fewer number of rows in master means fewer iterations of join comparison.

Secondly It is easier to cache the table with fewer number of rows.

Hence using the table having the fewer number of rows as a master improves the performance.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

January 14, 2009 06:36:27

samirdesai999

Member Since: January 2009 Contribution: 4

RE: Joiner Transformation Master Detail

We should consider cardinality (lesser number of unique records) on joining conditions for master rather then falling into straight statistics of rowcounts..!!
-- Sam

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank