You can view and configure the basic properties for a single-table constraint. The properties vary based on the types of objects you select for the single-table constraint.
Single-table constraint description. By default, Data Validation Option uses the table name.
You can configure the following properties for the table:
The table name. Select
to select a table. You can search for a data source by name or path. You can search for a lookup view, SQL view, join view, and aggregate view by name.
Connection properties for the selected table. Select
to edit the connection properties.
XML Group A
The XML group name for an XML data source. Only child elements of the XML group are available to use in the WHERE clause, primary key field, and tests.
The WHERE clause filters the records that are read from the data source. If the PowerCenter Integration Service processes the WHERE clause, enter a valid PowerCenter expression. If a relational, Salesforce, SAP, or SAS data source processes the WHERE clause, enter a WHERE clause that is supported by the data source.
Execute Where Clause in DB
If the data source is relational, Salesforce, SAP, or SAS, enable if you want the data source to process the WHERE clause. You must select this option to select the
Where Clause, Sorting and Aggregation in DB
Controls the test logic processed by the PowerCenter Integration Service and the data source. Select one of the following options:
Default. The PowerCenter Integration Service sorts the input data and processes all test logic.
WHERE clause, Sorting, and Aggregation in DB. If the data source is a relational data source, the database processes the WHERE clause, sorts records for joins, and aggregates data for aggregate tests. The PowerCenter Integration Service processes all remaining test logic that the data source does not process.
Already Sorted Input. Indicates that the records in the data source are already sorted. If the records in the data source are not sorted, tests might fail.
Primary key column or columns for the table.
The primary key columns that appear for an XML data source are based on the selected XML group. Only child elements of the selected XML data source appear as primary key columns.
Identifier for the single table that you can use when you run Data Validation Option tests at the command line.