Before you run tests, verify that the Data Validation Option target folder is closed in the PowerCenter Designer and the PowerCenter Workflow Manager. If the target folder is open and you run tests, Data Validation Option cannot write to the target folder and the tests fail.
Use one of the following methods to run tests:
Select one or more table pairs and click
Right-click a folder in the Navigator and select
Run Folder Tests.
Right-click a test on the
tab and select
Run Selected Tests.
Data Validation Option runs all tests for a single table together. You cannot run tests individually unless only one test is set up for the table. If you select an individual test, Data Validation Option runs all tests for the single table.
After you run a test, you can view the results on the
Data Validation Option uses the following logic to determine whether a test passes or fails:
An aggregate test is calculated as “value <operator> constraint.” If this relationship is true, the test passes. If the operator chosen is approximate, then the test is calculated as ABS(value-constraint) <= Threshold.
A VALUE test must produce fewer or an equal number of records that do not match compared to the threshold value. If there is no threshold value and there are no records that do not match, the test passes.
A FORMAT test is calculated as “value <operator> constraint.” If this relationship is true, the test passes.
A UNIQUE, NOT_NULL, or NOT_BLANK test passes if the field value is unique, is not null, or is not blank, respectively. For string values, not blank means the string is not null or empty. For numeric values, not blank means the number is not null or 0.