Inserting Master Data Services Domain Attributes Using Staging Attribute Table

Inserting Master Data Services Domain Attributes Using Staging Attribute Table.

You need to insert the following into the staging tables:

INSERT INTO [CPSRMS_MDS].[mdm].[tblStgMemberAttribute]

([UserName]

,[ModelName]

,[EntityName]

,[MemberType_ID]

,[MemberCode]

,[AttributeName]

,[AttributeValue]

,[Status_ID]

)

values( ‘Your User Name’ as UserName

,’Yout Model Name’ as ModelName

,’Your Entity Name’ as EntityName

,1 as MemberType_ID //This should be leaf

,Code as MemberCode //The Code of your child table

,’The Name of the Domain Attribute You want to update’ as AttributeName

,The MemberCode of the Parent Entity that you want to set the child field to.

,0 as Status_ID

)