You can configure bad records, a parameter file, sampling, and caching for a single-table constraint. The properties vary based on the types of objects you select for the single-table constraint.
You can configure the following properties for bad records:
Save All Bad Records for Test Execution
Saves all bad records for value and unique tests for single-table constraints.
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.
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>
Name of the parameter file. Click
to add a parameter file. Click
to delete the selected parameter file.
You can configure the following properties for data sampling:
Enable Data Sampling
Indicator that determines if data sampling is enabled.
Percentage of Rows
Percentage of rows that you want to sample. Minimum value is .000001. Maximum value is less than 100.
The starting value used to generate a random number for sampling. You can configure the seed value for the following platforms:
PowerCenter. Minimum seed value is 0. Maximum seed value is 4294967295.
IBM DB2. Minimum seed value is 1 - 10³¹. Maximum seed value is 10³¹ - 1.
Oracle. Minimum seed value is -2,147,483,648. Maximum seed value is 2,147,483,647.
Use Native Sampling
The database performs the sampling. If you do not enable this option, PowerCenter performs the sampling.
Total cache used to run PowerCenter sessions 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