Database Reference
In-Depth Information
Always verify that the master and detail sources are defined to enhance the performance.
It is always recommended that you create a table with a smaller number of records as the
master and the other as the detail. This is because Integration Service picks up the data
from the master source and scans the corresponding record in the details table. So if we
have a smaller number of records in the master table, fewer iterations of scanning will
happen. This enhances the performance.
