| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Joiner Transformation Master Detail
Answer: Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail? |
| August 08, 2008 13:57:49 |
#4 |
| ghola |
Member Since: July 2008 Total Comments: 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. |
| |
Back To Question | |
