Post reply

MDS not able to see the data inserted in the staging table on the Mds explorer

  • October 13, 2017 at 4:42 am

    #329159

    Dear all,

    I have this leaf table (with No hierarchies):


    [stg].[Databases_Leaf]
    ([ImportType]
    ,[ImportStatus_ID]
    ,[Batch_ID]
    ,[BatchTag]
    ,[ErrorCode]
    ,[Code]
    ,[Name]
    ,[NewCode]
    ,[AdditionalNotes])

    I have populated it with the following insert:


    insert into dwhMasterDataServices.[stg].[Databases_Leaf] (importtype,ImportStatus_ID,name) values (1,1,'dwhStaging')
    Then I have executed the below sp:
    exec stg.[udp_Databases_Leaf] 'VERSION_1', NULL, null, NULL

    Now, when I go to see if the data is able to be seen in the MDS explorer, no data appears.

    Can you please help me understand what am I doing wrong?

    Thank you

  • October 13, 2017 at 10:15 am

    #1963609

    What does that stored procedure do?   We don't have the code for it, so you'll have to provide it in order for anyone to have any idea what the problem might be.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply