Once you have loaded one or more of the staging tables with data, the majority of the practical work has been done. You can invoke the staging process using either the user interface or the T-SQL stored procedure. To understand what happens when the staging process runs, it is worth exploring exactly what happens in the MDS database when the process is invoked:
Batch_IDfor each record will be
mdm.udpStagingSweepstored procedure is called (either using the user interface or using T-SQL). This does the following:
mdm.udpStagingBatchSavestored procedure that does a simple insert into the ...