Table of Contents


  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

New Features and Enhancements (9.5.1)

New Features and Enhancements (9.5.1)

This section describes new features and enhancements in version 9.5.1.


You can configure caching for table pairs and single-table constraint tests in the Data Validation Client.


You can add a file list to the connection for a single-table constraint or table pair. When you specify a file list, Data Validation Option processes all files in the list.

Data Validation Client

The user interface contains the following enhancements:
  • The
    Table Pair Test Editor
    Single Table Test Editor
    dialog boxes have a new layout.
  • You can view longer column names in the
    Column Definition
    area of the
    SQL View Editor
    dialog box.

DVOCmd Commands on UNIX

You can run the following DVOCmd commands on UNIX:
  • InstallTests
  • RefreshRepository
  • RunTests
  • UpgradeRepository

Join Views

You can select an SQL view as a data source for a join view.

Metadata Export and Import

  • You can skip objects that are not valid when you export metadata.
  • You can use the Data Validation Client to edit the metadata before you import it.

Operating System Support

Data Validation Option supports Informatica Services versions 9.5.0 and higher on AIX 7.1.

PowerCenter Session Logs

You can right-click a single table or table pair to view test errors in the PowerCenter session log.


You can configure sampling to reduce the number of rows processed when you test data sets in table pairs and single-table constraints. You can use a seed value to repeat the same sample in a test. If you are sampling data from IBM DB2, Microsoft SQL Server, Oracle, or Teradata, you can perform native sampling in the database. Push sampling to the database to increase performance.