Once the staging process is complete, you can optionally validate your model to ensure that any business rules you have set up are applied, any members breaking these rules are marked as invalid, and notifications can be sent to MDS users if required.
As with all our previous steps, this can be achieved either using the MDS user interface or by calling a T-SQL stored procedure. Using the user interface to validate your model is covered in detail in Chapter 5, so we won't go over this again here.
Note
Important—If you call the validation process before the staging process is complete, some or all of your members may not be validated.
As with the staging process, the validation process is run for a particular model and version. The stored procedure for validating a model is called mdm.udpValidateModel
and its definition is shown below:
mdm.udpValidateModel