Table of Contents

Search

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