Consolidated Member Staging Table (Master Data Services)
Applies To: SQL Server 2016 Preview
Use the consolidated members staging table (stg.name_Consolidated) in the Master Data Services database to create, update, deactivate, and delete consolidated members. You can also use it to update attribute values for consolidated members.
The following table explains what each of the fields in the Consolidated staging table are used for.
An automatically assigned identifier. Do not enter a value in this field. If the batch has not been processed, this field is blank.
Determines what to do when staged data matches data that already exists in the Master Data Services database.
The status of the import process. Possible values are:
Required by web service only
An automatically assigned identifier that groups records for staging. All members in the batch are assigned this identifier, which is displayed in the Master Data Services user interface in the ID column.
If the batch has not been processed, this field is blank.
Required, except by web service
A unique name for the batch, up to 50 characters.
The explicit hierarchy name. Each consolidated member can belong to one hierarchy only.
Displays an error code. For all records with a ImportStatus_ID of 2, see Staging Process Errors (Master Data Services).
Required, except when codes are generated automatically for ImportType 1 or 2; see Automatic Code Creation (Master Data Services) for more information
A unique code for the member.
A name for the member.
Use only if you are changing the member code.
A column exists for each attribute in the entity. Use this with an ImportType of 0 or 2. For free-form attributes, specify the new text or string value for the attribute. For domain-based attributes, specify the code for the member that will be the attribute. For link attributes, the URL must start with http://.
Load or Update Members in Master Data Services by Using the Staging Process
Move Explicit Hierarchy Members by Using the Staging Process (Master Data Services)
Importing Data (Master Data Services)
View Errors that Occur During the Staging Process (Master Data Services)
Staging Process Errors (Master Data Services)