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 |
---|---|---|
Identity column used as internal key. | ||
int |
Updated with the id of the batch once the staging process is invoked. | |
nvarchar(100) |
The name of the user running the staging process batch in format 'domain\username' – optional. | |
nvarchar(50) |
The name of the model into which the row is to be loaded. | |
nvarchar(50) |
The name of the hierarchy into which the row is... |