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

Adding a Table Pair

Adding a Table Pair

You can create a table pair from the file menu or from the shortcut in the menu bar.
  1. Select the folder to which you want to add the table pair.
  2. Right-click the folder and select
    Add Table Pair
    .
    The
    Table Pair Editor
    window appears.
  3. On the
    Basic
    tab, enter the basic properties of the table pair.
    The following figure shows the
    Basic
    tab for a relational connection: The Basic tab shows a table pair between the DIMEMPLOYEES table in the DVO_Training_Oracle connection and the DIMEMPLOYEES table in the DVO_Upgrade_Oracle connection. The table pair contains a join condition based on the EMPLOYEEID columns in both tables.
  4. Enter values for the basic properties on the
    Basic
    tab.
  5. Click
    Edit
    to configure the connection properties for a table.
  6. Click the
    Advanced
    tab and enter values for the advanced properties.
    The following figure shows the
    Advanced
    tab: The Advanced tab contains four sections. In the Bad Records section, you can configure whether to save the bad records to a flat file or to the Data Validation Option repository. If you save to a flat file, you can specify the flat file name in the File Name property. If you use parameters, you can specify the parameter file name and parameters in the Parameters section. If you specify a parameter, you specify the parameter name, data type, precision, and scale. Click Add to add a parameter. Click Delete to remove a parameter. In the Data Sampling section, you can enable data sampling, specify which table in the table pair to apply sampling, specify the percentage of rows that you want to sample, and specify a seed value. You can also specify whether to perform native sampling.
  7. Click
    Save
    to save the table pair.