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

Test Conditions

Test Conditions

A test condition filters the records processed by a test in a single table or table pair. To increase the performance of a particular test defined for a single table or table pair, add a test condition.
For example, you want to exclude telephone extension numbers from a VALUE test for a table pair. You want to exclude telephone extension numbers that contain fewer than three characters.
Create the VALUE test based on the following criteria:
  • Table A.EXT = Table B.EXT
  • Condition A = LENGTH(EXT)<3
  • Condition B = LENGTH(EXT)<3
Add a test condition instead of a WHERE clause when you want to apply the filter on a particular test. If you enter a test condition and WHERE clause in a single table or table pair, Data Validation Option applies the WHERE clause to all tests before it applies the test condition.
If you create a test condition and WHERE clause on a joined table pair, Data Validation Option applies the WHERE clause before it joins the tables. Data Validation Option applies the test condition after it joins the tables.