Table of Contents


  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

Advanced Properties for a Table Pair

Advanced Properties for a Table Pair

You can configure bad records, a parameter file, sampling, and caching for a table pair. The properties vary based on the types of objects you select for the table pair.

Bad Records

You can configure the following properties for bad records:
Save All Bad Records for Test Execution
Saves all bad records for value, outer value, and set tests for table pairs.
Write Bad Records to:
The location where Data Validation Option writes bad records. You can select one of the following options:
  • Flat File. Data Validation Option writes bad records to the specified flat file.
  • DVO Schema. Data Validation Option writes bad records to the Data Validation Option repository.
File Name
The location and name of the flat file to which Data Validation Option writes bad records. Default location is
$INFA_HOME/server/infa_shared/BadFiles/<single table name /table pair name>/<file name>


Parameter File
Name of the parameter file. Click
to add a parameter file. Click
to delete the selected parameter file.

Data Sampling

You can configure the following properties for data sampling:
Enable Data Sampling
Indicator that determines if data sampling is enabled.
Apply Sampling on:
The table on which you want to apply sampling.
Percentage of Rows
Percentage of rows that you want to sample. Minimum value is .000001. Maximum value is less than 100.
Seed Value
The starting value used to generate a random number for sampling. You can enter a seed value for the following platforms:
  • PowerCenter. Minimum is 0. Maximum is 4294967295.
  • IBM DB2. Minimum is 1 - 10³¹. Maximum is 10³¹ - 1.
  • Oracle. Minimum is -2,147,483,648. Maximum is 2,147,483,647.
Use Native Sampling
The database performs the sampling. If you do not enable this option, PowerCenter performs the sampling.

Cache Size

Cache Size
Total cache used to run a PowerCenter session associated with the table pair. By default, the units are bytes. Append KB, MB, or GB to the value to specify other units. For example, you can specify 1048576, 1024 KB, or 1 MB. Select
to enable PowerCenter to compute the cache size.


We’d like to hear from you!