Aggregate Transformation Function Dialog
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.
Click Next to continue.
Copyright © 2006, 2008, Oracle. All rights
reserved.