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

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.

0 COMMENTS

We’d like to hear from you!