Answer Detail: RE: Joiner Transformation Master Detail

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?

February 02, 2008 16:14:22	#2
Sreeya	Member Since: February 2008 Total Comments: 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.

Back To Question