Setting Data Profiling Constraints

PowerDesigner supports data profiling in the physical data model (PDM) and the Standard Checks and Additional Checks tabs are provided in OOM attribute and domain property sheets solely to retain this information when linking and synching between an OOM and a PDM.

The following constraints are available on the Standard Checks tab of OOM attributes and domains:

Property	Description
Values	Specifies the range of acceptable values. You can set a: Minimum - The lowest acceptable numeric value Maximum - The highest acceptable numeric value Default - The value assigned in the absence of an expressly entered value.
Characteristics	Specifies the shape of acceptable data. You can choose a: Format - A number of standard formats are available in the list and you can create your own format for reuse elsewhere or simply enter a format in the field. Unit - A standard measure. This field is informational only and is not generated. No space - Space characters are not allowed. Cannot modify - The value cannot be updated after initialization.
Character case	Specifies the acceptable case for the data. You can choose between: Mixed case [default] Uppercase Lowercase Sentence case Title case
List of values	Specifies the various values that are acceptable. Select the Complete check box beneath the list to exclude all other values not appearing in the list.

Creating Data Formats For Reuse
You can create data formats to reuse in constraints for multiple objects by clicking the New button to the right of the Format field on the Standard Checks tab. Data formats are informational only, and are not generated as constraints.
Specifying Advanced Constraints
The Additional Checks tab is used in the physical data model (PDM) to specify complex column constraints, and is provided in OOM attribute and domain property sheets solely to retain this information when linking and synching between an OOM and a PDM.

Parent topic: Attributes (OOM)