none
De-activating member not working in MDS

    Question

  • 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?

     

    Example:

    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
    Friday, January 27, 2012 6:28 AM

All replies