Validating prior to importing to MDS

Question

I am using the stored procs [stg].[upd_name_Leaf] to import data into MDS, and after it I use mdm.upd ValidateModel to validate the new staged data.  However, it would seem to me you wouuld want to validate first and then import into your Master data.  Is this possible?

---

Javier Guillen
http://javierguillen.wordpress.com/

Answer 1

We do a significant level of data validation in our operational data store, and then import to MDS.  Our 'business rules' then, are not really setup to do validation.  The validation is done through FK relationships / etc in our ODS and as part of our ETL.