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:
Data is inserted into one or more of the staging tables. The
Batch_IDfor each record will beNulland theStatus_IDwill be0.The
mdm.udpStagingSweepstored procedure is called (either using the user interface or using T-SQL). This does the following:Calls the
mdm.udpStagingBatchSavestored procedure that does a simple insert into themdm.tblStgBatchtable. This returns aBatch_ID.Updates any new records in the
mdm.tblStgMemberwith theBatch_ID.Updates any new records in
mdm.tblStgMemberAttributewith theBatch_ID.Updates any new records in
mdm.tblStgRelationshipwith theBatch_ID...