PowerCenter
- PowerCenter 10.5.2
- All Products
Property
| Description
|
---|---|
Function
| The test you run such as COUNT, COUNT_DISTINCT, VALUE, or NOT_NULL.
|
Field
| The field that contains the values you want to test.
|
Operator
| The operator that defines how to compare each value in the field with the constraint value.
|
Constraint Value
| The value or values you want to compare the field values to.
|
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 number of records that can fail 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 on string data.
|
Trim Trailing Spaces
| Ignores trailing spaces when you run a test that on string data. Data Validation Option does not remove the leading spaces in the string data.
|
Condition
| Filter condition for the test. Enter a valid PowerCenter Boolean expression.
|
Field is Expression
| Allows you to enter an expression for the field.
|
Datatype
| The datatype for the expression if the field is an expression.
|
Precision
| The precision for the expression if the field is an expression.
|
Scale
| The scale for the expression if the field is an expression. Maximum value is 99.
|
Comments
| Information about a test. Data Validation Option displays the comments when you view test properties in the Properties area.
|