Validation - Fusion - Match_and_Merge - 3.1

EnterWorks Fusion

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > Fusion
Precisely EnterWorks > Match and Merge
Version
3.1
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Fusion
Copyright
2023
First publish date
2007
ft:lastEdition
2024-03-02
ft:lastPublication
2024-03-02T02:58:49.255209

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.

  • Check constraints.

  • Aggregate constraints.

Unique 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.

Check Constraints

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 SQL).

Aggregate Constraints

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 $a to 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.

Filter

Aggregate

Condition

status = 'active'

count(*)

$a between 1500 and 2000