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 1 populating the staging tables

Populating the staging tables with your source data in the correct format is the core part of getting data loaded into MDS. Once this is done correctly, MDS (almost) takes care of the rest. The process is very similar for each of the staging tables and in fact each of the stage tables is used for more than one process. To understand how to populate the tables, it is important to look at the definition for each of the staging tables, and the uses of each field:

tblStgMember

Field name

Data type

Description

ID

bigint

Identity column used as internal key.

Batch_ID

int

Updated with the id of the batch once the staging process is invoked.

UserName

nvarchar(100)

The name of the user ...

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