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

Data Validation Table Objects

Data Validation Table Objects

A data validation table object (table object) is a data validation object that defines the set of data that you want to validate. It can contain one or more data sources or data validation views. You can create multiple validation tests based on one table object.
When you create a table object, you configure properties used to perform tests against the data. For example, you can choose to test a sampling of the data if you do not need to perform tests against the entire data set. You might also choose to configure an external ID that you can use to run tests from DVOcmd.
You can create the following types of table objects:
Single table object
A single table object represents one data source or validation view that you want to test. You must configure a primary key in a single table object. You might create a single table object to verify data, such as average sales, when you do not need to reconcile it to another data set.
Table pair object
A table pair object represents two data sources or validation views. Create a table pair object to compare one data source to another. You must configure the key relationships between the sources in a table pair object. You might create a table pair object to compare migrated data against the source of the migration.