Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Datatype Reference
  22. Reporting Views
  23. Metadata Import Syntax
  24. Jasper Reports
  25. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Running Single-Table Constraint Tests

Running Single-Table Constraint Tests

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
    Run Tests.
  • Right-click a folder in the Navigator and select
    Run Folder Tests.
  • Right-click a test on the
    Tests
    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
Results
tab.
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.