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.