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:
|
Characteristics |
Specifies the shape of acceptable data. You can choose a:
|
Character case |
Specifies the acceptable case for the data. You can choose between:
|
List of values |
Specifies the various values that are acceptable. 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. |