Setting Data Profiling Constraints

PowerDesigner allows you to define data profiling constraints to control the range and format of data allowed in your database. You can specify constraints on the Standard Checks and Additional Checks tabs of table columns in your PDM, entity attributes in your CDM or LDM, and domains. You can also specify data quality rules on the Rules tab of PDM tables and columns, CDM/LDM entities and attributes, and domains.

The following constraints are available on the Standard Checks tab of PDM columns, CDM/LDM entity attributes, and CDM/LDM/PDM 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. For the PDM, you can directly enter a default value or select a keyword (defined in the Script\Sql\Keywords\ReservedDefault entry of the DBMS definition file) from the list. Default objects (see Defaults (PDM)) are also available for selection if your DBMS supports them.
Characteristics	These properties are for documentation purposes only, and will not be generated. You can choose a: Format - A number of standard formats are available in the list. You can enter a new format directly in the field or use the tools to the right of the field to create a data format for reuse elsewhere. Unit - A standard measure. 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. When specifying strings in the list of values, single or double quotation marks (depending on the DBMS) will be added around the values in the generated script unless: You surround the value by the appropriate quotation marks. You surround the value by tilde characters. The value is a keyword (such as NULL) defined in the DBMS. PowerDesigner does not recognize your data type as a string. The following examples show how string values are generated for a DBMS that uses single quotation marks: `Active` - generates as `'Active'` `'Active'` - generates as `'Active'` `"Active"` - generates as `'"Active"'` `~Active~` - generates as `Active` `NULL` - generates as `NULL` If you have specified a non-automatic test data profile, you can use the values defined in the profile to populate the list by clicking the Update from Test Data Profile tool. Select the Complete check box beneath the list to exclude all other values not appearing in the list.

Specifying Constraints Through Business Rules
In addition to the constraints specified on the Standard Checks tab, you can specify business rules of type Validation or Constraint to control your data. Both types of rule contain SQL code to validate your data, and you can attach them to tables and table columns in your PDM, entities and entity attributes in your CDM or LDM, and domains.
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 initialized with PowerDesigner variables to generate the data profiling constraints specified on the Standard Checks tab and the validation rules specified on the Rules tab. You can edit the code on this tab by entering an appropriate SQL expression to supplement, modify, or replace these constraints.

Parent topic: Columns (PDM)