Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Attributes Staging Table (Master Data Services)

Use the attributes staging table (mdm.tblStgMemberAttribute) in the Master Data Services database to:

  • Update attribute values of existing members and collections.

  • Delete members or collections.

  • Reactivate members or collections.

This topic contains the following sections:

Column Name

Description

ID

Displays an automatically assigned identifier. If the batch has not been processed, this field is blank.

Batch_ID

Displays 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 Manager user interface in the ID column. This value is also in mdm.tblStgBatch, in the ID field.

If the batch has not been processed, this field is blank.

UserName

Optional value. Specify a user name to filter the records in the Master Data Manager user interface. The logged in user can view:

  • Records for his or her user name, and

  • Records with no user name assigned.

The user name should match the name in the Master Data Manager Users list, for example DOMAIN\user_name or server\user_name.

ModelName

Required value. Specify the case-sensitive name of the model.

EntityName

Required value. Specify the name of the entity.

MemberType_ID

Required value. Specify the type of member. Possible values are:

  • 1 to indicate leaf member.

  • 2 to indicate consolidated member.

  • 3 to indicate collection.

MemberCode

Required value. Specify the code for the member that you want to update.

AttributeName

Required value. Specify the attribute name.

You can use MDMMemberStatus for AttributeName to deactivate or reactivate a member or collection. For more information, see How to: Delete a Member or Collection by Using tblStgMemberAttribute (Master Data Services) and How to: Reactivate a Member or Collection by Using tblStgMemberAttribute (Master Data Services).

AttributeValue

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.

If you leave this field blank, when the staging process runs, the attribute value is updated to a blank value. The only exceptions are numeric values, date values, or the Name attribute. These cannot be assigned a blank value through staging.

If you used MDMMemberStatus for AttributeName, use De-Activated or Active for AttributeValue.

NoteNote
You cannot stage file attributes.

Status_ID

Displays the status of the import process. Possible values are:

  • 0, which you specify to indicate that the record is ready for staging.

  • 1, which is automatically assigned and indicates that staging for the record has succeeded.

  • 2, which is automatically assigned and indicates that staging for the record has failed.

ErrorCode

Displays an error code. For all records with a Status_ID of 2, view the Staging Batch Errors page in Master Data Manager for a more detailed description.

You can save the following examples to a flat file and import them into your Master Data Services database if you have completed the following tasks:

For more information about importing data into a database by using SQL Server Integration Services, see How to: Run the SQL Server Import and Export Wizard.

Updating attribute values

The following example shows how to update an attribute value for a leaf member, a consolidated member, and a collection.

  • The first line in this example contains the column names.

  • The second line updates the DaysToManufacture attribute value to 4 for the BK-M101 leaf member.

  • The third line sets the Name attribute value to Men/Women for the MW consolidated member.

  • The fourth line sets the Description attribute value to John Yokim's Products for the JR collection.

    ModelName,EntityName,MemberType_ID,MemberCode,AttributeName,AttributeValue
    Product,Product,1,BK-M101,DaysToManufacture,4
    Product,Product,2,MW,Name,Men/Women
    Product,Product,3,JR,Description,John Yokim's Products
    

Deleting a member

The following example shows how to delete a member by using MDMMemberStatus for the attribute and De-Activated for the attribute value.

ModelName,EntityName,MemberType_ID,MemberCode,AttributeName,AttributeValue
Product,Product,1,BK-M101,MDMMemberStatus,De-Activated

For more information, see How to: Delete a Member or Collection by Using tblStgMemberAttribute (Master Data Services).

Reactivating a member

The following example shows how to reactivate a deleted member by using MDMMemberStatus for the attribute and Active for the attribute value.

ModelName,EntityName,MemberType_ID,MemberCode,AttributeName,AttributeValue
Product,Product,1,GUID,MDMMemberStatus,Active

For information about how to determine the GUID, see How to: Reactivate a Member or Collection by Using tblStgMemberAttribute (Master Data Services).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.