- PowerCenter 10.2
- All Products
Description of aggregate view.
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.
PowerCenter connection to the source tables, target tables, or views.
Name of the group if you use an XML, a PowerExchange for IMS, COBOL, or VSAM data source.
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 DBif 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.
The optimization level controls the test logic processed the data source. Select one of the following options:
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.