Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Basic Properties for a Table Pair

Basic Properties for a Table Pair

You can view and configure the basic properties for a table pair. The properties vary based on the types of objects you select for the table pair.

Description

Description
Table pair description. By default, Data Validation Option uses "Joined <Table A>-<Table B>" for joined table pairs. It uses "<Table A>-<Table B>" for table pairs that are not joined.

Table A/B

You can configure the following properties for Table A and Table B:
Table A/B
The first or second table in the table pair. Select
Browse
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, or aggregate view by name.
Conn A/B
Connection properties for the table. Select
Edit
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, table join field, and tests.
Where Clause A/B
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
optimization level.
Optimization Level
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.

Table Join

Join Field A/B
Join condition for the table pair. Select
Expression
to insert an expression for a join field. If you enter an expression for a join field, click
Validate
to validate the expression.
If you enter an expression for a join field, you cannot save the table pair until you enter a valid expression.

External ID

External ID
Identifier for the table pair that you can use when you run Data Validation Option tests from the command line.