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

Automatic Test Generation for Table Pairs

Automatic Test Generation for Table Pairs

You can automatically generate tests for tables pairs to create tests quickly. You can generate tests between columns that have the same name or same position.
When you generate tests based on column names, Data Validation Option matches columns that have the same name and generates tests for each set of matched columns. Data Validation Option performs a case-sensitive match.
When you generate tests based on column position, Data Validation Option matches columns based on their column position in the table and generates tests for the matched columns. For example, Data Validation can generate tests between the third columns of both tables.
You can use the following methods to generate table-pair tests:
Select the Generate Value Tests option.
Use this method if you want to generate count and value tests for an existing table pair based on matching columns.
Import tests from a spreadsheet.
Use this method to generate all types of tests for an existing table pair. For example, you can generate count, value, MIN, AVG, and SET_AinB tests. You can also use this method to generate tests if you want to work offline or if you are not a Data Validation Option user.
Run a table comparison.
Use this method to generate table pairs between tables and flat files in two PowerCenter folders and generate count and value tests for each table pair.