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.

In addition, for columns, you can override the default Constraint name:

Constraint Name
The following variables are inserted by default:

  • %MINMAX% - Minimum and maximum values specified on the Standard Checks tab

  • %LISTVAL% - List of values specified on the Standard Checks tab

  • %CASE% - Character case specified on the Standard Checks tab

  • %RULES% - Constraint and validation rules specified on the Rules tab

Parent topic: Setting Data Profiling Constraints