O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Populating MDS step 2 invoking the staging process

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:

  1. Data is inserted into one or more of the staging tables. The Batch_ID for each record will be Null and the Status_ID will be 0.
  2. The mdm.udpStagingSweep stored procedure is called (either using the user interface or using T-SQL). This does the following:
    • Calls the mdm.udpStagingBatchSave stored procedure that does a simple insert into the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required