Friday, January 27, 2012 6:28 AM
I will not repeat that that is told to me. The same problem as under the reference http://social.msdn.microsoft.com/Forums/en-US/sqlmds/thread/1886673e-c80e-442c-8d17-21aee717624f :
I try to de-activate a member using mdm.tblStgMemberAttribute table. I use the below code to de-activate member. It is not working. When I do processing, the processing does not do anything with respect to this staged row. The Membercode is not getting deactivated. Please let me know whether I am doing something wrong?.....
A thread result - its bug of MDS. Prompt if changes on the given problem?
ETL insert data:
INSERT INTO [mdm].[tblStgMemberAttribute ([ModelName],[EntityName],[MemberType_ID],[MemberCode],[AttributeName],[AttributeValue])
VALUES ('NSI', N'Grain', 1, N'209', 'MDMMemberStatus', 'De-Activated')
And call EXECUTE mdm.udpStagingSweep @User_ID, @Version_ID, 1
After end of processing the batch this record have Status_ID=0 in tblStgMemberAttribute. What not affect on the record in entity table tbl_2_68_EN in my model.
- Edited by Raiden Friday, January 27, 2012 7:28 AM
Monday, April 30, 2012 8:06 AM
If you are using SQL Server MDS 2012 you should try using entity based staging to do this. Here's some documentation to get you started:
Arunjeet Singh (Microsoft SQL Server Master Data Services)