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

Aggregate View Properties

Aggregate View Properties

When you create an aggregate view, you specify the aggregate view properties.
The following table describes the aggregate view properties:
Property
Description
Description
Description of aggregate view.
Select Table
Name of the table included in the aggregate view.
Provide Data Validation Option with information to create an aggregate view. Specify the tables that you want to include in the aggregate view.
Connection
PowerCenter connection to the source tables, target tables, or views.
Group Name
Name of the group if you use an XML, a PowerExchange for IMS, COBOL, or VSAM data source.
WHERE Clause
The WHERE clause filters the records that are read from the data source. Enter a valid PowerCenter expression.
Execute Where Clause in DB
Indicator that specifies that the data source must use the WHERE clause.
If the data source is relational, Salesforce, SAP, or SAS, select
Execute Where Clause in DB
if you want the data source to process the WHERE clause.
If you do not select this option, the aggregate view filters the data before performing aggregations.
Optimization Level
The optimization level controls the test logic processed the data source. Select one of the following options:
  • Default. Sorts the source data before performing aggregations.
  • 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.
Columns
The columns that you want to include in the aggregate view. Data Validation Option imports all tables that you select. You can create, edit, delete, and rearrange columns.