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.
Parent topic: Attributes (OOM)