locked
Using mdm.updValidateModel RRS feed

  • Question

  • I have an SSIS package that load data into MDM and then the package polls MDS to verify the counts are the same as the staging table.  After the staging table and the MDM table hold the same count, the sp mdm.udpValidateModel runs.  This does not validate, that is, run the business rules on the new data.

    Later, if I run the either mdm.udpValidateModel or use the "Version Management" tab, the validation, business rules, run.

    Any thoughts?

     

    Thanks,

    Rick

    Monday, March 21, 2011 8:15 PM

Answers

  • Hi Rick,

    So if I've understood correctly, you're running mdm.udpValidateModel twice, but it only runs the business rules the second time?

    When you say the "MDM" table, I'm guessing you may mean the internal MDS table that gets populated when you run the staging sweep stored procedure. If that's the case, then I would have thought your method is pretty solid, although I've not done the staging that way. The way that I've always approached it is to wait until the Status_ID field is 2 in the mdm.tblStgBatch table for the batch that corresponds to your staging rows. Once the status is 2, then I run mdm.udpValidateModel.

    This is outlined in the following blog post:

    http://sqlblog.com/blogs/mds_team/archive/2010/02/10/Importing-Data-by-Using-the-Staging-Process.aspx

    Hope that helps

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx
    • Marked as answer by rick_mds Wednesday, March 23, 2011 6:43 PM
    Monday, March 21, 2011 10:58 PM

All replies

  • Hi Rick,

    So if I've understood correctly, you're running mdm.udpValidateModel twice, but it only runs the business rules the second time?

    When you say the "MDM" table, I'm guessing you may mean the internal MDS table that gets populated when you run the staging sweep stored procedure. If that's the case, then I would have thought your method is pretty solid, although I've not done the staging that way. The way that I've always approached it is to wait until the Status_ID field is 2 in the mdm.tblStgBatch table for the batch that corresponds to your staging rows. Once the status is 2, then I run mdm.udpValidateModel.

    This is outlined in the following blog post:

    http://sqlblog.com/blogs/mds_team/archive/2010/02/10/Importing-Data-by-Using-the-Staging-Process.aspx

    Hope that helps

    Jeremy


    http://blogs.adatis.co.uk/blogs/jeremykashel/default.aspx
    • Marked as answer by rick_mds Wednesday, March 23, 2011 6:43 PM
    Monday, March 21, 2011 10:58 PM
  • Hi Jeremy,

    Yes you understood my question correctly.  Your suggestion work great. 

    Thank you for your assistance.  I am working on writing straight to the tables, as in the doc.

    Rick

     

    Wednesday, March 23, 2011 6:42 PM