Validation allows you to check the correctness of data by specifying and evaluating various types of constraints.
To implement Validation, first create a Validation Specification. How do I create Validation Specifications? Standardization specifications are located in the Standardization subsection of the Specifications section in the navigation tree. After creating a Standardization specification you can:
Run it and see the result by right clicking on the specification name;
Or add the Validate operation to a scenario that runs the specification.
A validation specifications contains Source, Space, and Table fields that define the table for which you want to specify constraints. You can specify the following types of constraints:
Unique constraint or primary key constraint.
Unique constraint consists of a list of columns whose values must be unique among all records in the table. If you check the primary key checkbox, you add the additional requirement that the value of the listed columns cannot be null.
You can specify any number of check constraints. A check constraint is an expression
in the data source supported language (for example, SQL) that must evaluate to true
for all records of the table. Check constraints are a general mechanism that allows
you to express many types of data validation constraints. For example, a NOT NULL
constraint can be expressed as:
<columnName> is not null (in
You can specify any number of aggregate constraints. An aggregate constraint consists of the following components, (all the components are specified in a language supported by the data source):
Filter: a predicate expression that allows computation of the aggregate only on a subset of the table records.
Aggregate: an aggregate expression computed over the table records.
Condition: a predicate expression on the result of the aggregate expression that must evaluate to true. Use
$ato refer to the result of the aggregate expression in the condition.
For example, the following constraints (in SQL) specify that the number of active customers must be in a range of 1500 to 2000.
status = 'active'
$a between 1500 and 2000