| Aggregator transformation is a active and connected. |
| Performs aggregate calculations |
| Components :: |
-
Aggregate expression. Entered in an output port. Can include non-aggregate expressions and conditional clauses.
-
Group by port. Indicates how to create groups
-
Sorted input. Use to improve session performance. To use sorted input, you must pass data to the Aggregator transformation sorted by group by port, in ascending or descending order.
-
Aggregate cache. The PowerCenter Server stores data in the aggregate cache until it completes aggregate calculations. It stores group values in an index cache(10000) and row data in the data cache(20000).
|
| |
| Aggregate Functions :: |
| AVG |
COUNT |
FIRST |
LAST |
MAX |
MEDIAN |
MIN |
PERCENTILE |
STDDEV |
SUM |
VARIANCE |
|
|
| |
| ** Use them in an expression within an Aggregator transformation |
| |
