Controlling Non-Divergence from a Domain

You can specify which of the properties of your domains must be applied to the columns or entity attributes associated with the domain, and which propeties are permitted to diverge.

1. Select  Tools  Model Options  to open the Model Options dialog box. In a PDM, click the Column and Domain sub-category in the left-hand Category pan:
   
   
   
2. Select the checkboxes of the column or entity attribute properties that you want to prevent from diverging from those defined in the domain:
   • Data type - Data type, length, and precision.
   • Check (see Setting Data Profiling Constraints).
   • Rules (see Business Rules (CDM/LDM/PDM)).
   • Mandatory – Mandatory property of the column or attribute.
   • [PDM] Profile (see Populating Columns with Test Data).
3. Click OK to close the dialog and return to your model.

   You are prompted to apply domain properties to columns or attributes currently attached to the domain. If you click OK, the properties of these objects are modified in order to be consistent with the properties of their domain.

   If you subsequently modify properties of the domain that are not selected for enforcement, you will be prompted to apply your changes to the columns or attributes attached to the domain. To choose not to apply your changes, deselect the appropriate checkbox. Properties that are enforced may not be deselected and if you only modify enforced properties, then this dialog will not be displayed.
   
   

   Note Properties specified as non-divergent are read-only in lists and property sheets for associated columns and attributes. If you want to modify a non-divergent column or attribute property, you must detach the column or attribute from its domain.