August 2017
Beginner to intermediate
426 pages
9h 36m
English
By default, when you add the first source, it becomes Detail and the other becomes Master. You can decide to change the master or detail source. To make a source the Master source, check the Master port for the corresponding source as shown in the following screenshot:

Always verify that the Master and Detail sources are defined to enhance the performance. It is always recommended to make the table with less number of records the Master and the other one Details. This is because Integration service picks the data from the Master source and scans the corresponding record in the Details table. So, if we have less number ...
Read now
Unlock full access