Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: 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.