OWB - Aggregator operator

Card Puncher Data Processing


The Aggregator operator calculates data aggregations on the input data. It provides an output row set that contains the aggregated data.

Aggregator operator is the “group by” clause in Sql.

You can define in the properties :

  • the group by clause
  • the having clause

To define an aggregate formula, you have to click in the column of the output group, goes to the properties and put your formula in the expression.

Aggregate Operator


Discover More
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...

Share this page:
Follow us:
Task Runner