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 Client

Data Validation Client

The Data Validation Client is the client application that you use to configure and perform data validation operations.
When you log in to the Data Validation Client, your user workspace shows objects that you created or that have been copied into your user workspace. You can change objects in your user workspace.
The following image shows the Data Validation Client user interface:
The Data Validation Client has a Navigator on the left-hand side where you can view repositories and repository objects. The right-hand side contains object details and test results.
  1. Shortcuts
  2. Navigator
  3. Details Area
  4. Properties Area
  5. Status Bar
The Data Validation Client can display the following areas:
Shortcuts
Enable you to perform common tasks such as adding table pairs and single tables, adding and running tests, editing and deleting objects, generating reports, and running dashboards.
Navigator
Displays and organizes the following type of objects:
  • Data Validation Option objects. You can view all Data Validation option folders, views, table objects, and tests objects for the Data Validation Option user that is logged in to Data Validation Option. The default folder contains table objects that you create in this folder. All folders, including the default folder, appear under the Tests node in the Navigator.
  • PowerCenter objects. You can view PowerCenter repositories, folders, sources, and targets. The Navigator contains all PowerCenter repositories that you add to Data Validation Option. Expand INFA Repositories to view the PowerCenter repositories. Expand a repository to view the repository folders and the sources and targets in each folder.
Details area
Displays details about the objects that you create in the Data Validation Client, such as tests, table pairs, single tables, and views.
When you select a folder, table pair, or single table, the details area displays the following information about the tests associated with the object:
  • Number of tests
  • Number of tests passed
  • Number of tests failed
  • Number of tests in progress
  • Number of tests not run because of errors
  • Number of tests not run by the user
Properties area
Displays the following views based on the object that you select in the Navigator:
  • Properties
    view. When you select an object in the details area, displays properties about the object.
  • Results
    view. When you select a test or table object in the details area, displays test summary information, such as the test status, total number of records, and the number of bad records.
  • Bad Records
    view. When you select a failed test, displays the bad records written to the Data Validation Option repository.
Statistics area
Appears when you select the Data Validation Option user in the Navigator. This area displays the number of repositories, table pairs, single tables, tests, views, and data sources that exist in the Data Validation Option repository. This area also displays information about running tests.
Status bar
Displays the number of tests in progress and the number of tests in queue to run.