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. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Running Table-Pair Tests

Running Table-Pair Tests

You can run tests from the Data Validation Client or the DVOCmd command line.
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:
  • To run all tests defined for a table pair, right-click the table pair object in the Navigator, and click
    Run Table Pair Tests
    .
  • To run tests for all table pairs in a folder, right-click the folder in the Navigator and select
    Run Folder Tests.
After you run a test, you can view the results on the
Results
view in the
Properties
area.
Data Validation Option uses the following logic to determine whether a test passes:
  • For an aggregate test, the
    A <operator> B
    statement must be true. For example, the following statement must be true:
    A > B
  • For a test that uses the approximate operator, the
    ABS(A-B) <= Threshold
    statement must be true.
  • For a value or set test, the number of records that do not match must be fewer than or equal to the threshold value. If there is no threshold value and there are no records that do not match, the test passes.
To run multiple table pair objects in parallel on DVOCmd command line, you must first install the tests, and then run then the tests.