Property
| Description
|
---|---|
Function
| The test you run such as COUNT, COUNT_DISTINCT, AinB, or VALUE.
|
Field A/B
| The field that contains the values you want to compare when you run the test. You must select a field from each table in the table pair.
|
Operator
| The arithmetic operator that defines how to compare each value in Field A with each value in Field B.
|
Threshold
| The allowable margin of error for an aggregate or value test that uses the approximate operator. You can enter an absolute value or a percentage value.
|
Max Bad Records
| The maximum number of records that can fail the comparison for a test to pass. You can enter an absolute value or a percentage value.
|
Case Insensitive
| Ignores case when you run a test that compares string data.
|
Trim Trailing Spaces
| Ignores trailing spaces when you run a test that compares string data. Data Validation Option does not remove the leading spaces in the string data.
|
Null=Null
| Allows null values in two tables to be considered equal.
|
Condition A/B
| Allows you to filter records after Data Validation Option joins the tables in the table pair. Enter a valid PowerCenter Boolean expression.
|
Field A/B is Expression
| Allows you to enter an expression instead of a field name
|
Datatype
| The datatype of the expression if you enter an expression instead of the field name.
|
Precision
| The precision of the expression if you enter an expression instead of the field name.
|
Scale
| The scale for the expression if you enter an expression instead of the field name. Maximum value is 99.
|
Comments
| Information about a test. Data Validation Option displays the comments when you view test properties in the properties area.
|