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?

May 05, 2008 14:57:02	#3
franticsky	Member Since: May 2008 Total Comments: 2
RE: Joiner Transformation Master Detail
In order to boost performance always choose the tabel with lesser rows to be the master table

Back To Question