Aggregate Transformation Function Dialog
Use this dialog to define an aggregate function or attribute.
To define an aggregation function:
- A default Name is supplied for the function; you can change the default.
- Select a function from the Function dropdown list.
- Select ALL to include all values in the calculation; select DISTINCT to eliminate duplications before calculating.
- Select as Parameter the attribute whose values will be aggregated.
For example to specify the average of all of the AGE values, select the function AVG, select ALL, and select the parameter AGE.
To define an aggregation attribute:
- A default Name is supplied for the attribute; you can change the default.
- Select NONE from the Function dropdown list
- Select the appropriate value from ALL/DISTINCT
- Select a Parameter
For example, to specify LAST_NAME as an aggregation attribute, select NONE for function, select DISTINCT, and select the parameter LAST_NAME.
Click Next to continue.
Copyright © 2005, Oracle. All rights reserved.