Grouping Input Data

Oracle Java CAPS Data Integrator supports extracting aggregated data, applying special transformations, and loading them to a target table. Specific transformations are supported for aggregated values such as Minimum, Maximum, Count, Sum, and Average. You can aggregate column(s) based on a selection specified using the Group By Expression option. This option can only be used with Insert/Update statements.

To Group Input Data

1. Open the collaboration you want to edit.
2. In the ETL Collaboration Editor, right-click the target table and click Properties.

   The Properties panel appears.

3. Click the ellipsis button next to the Group By Expression property.

   The Group By Expression dialog box appears.

   ---

   Note - The Group By Expression option does not affect Upsert or Delete statements.

   

   ---

4. Select a column to add to the group by expression, and then click Add Column/Expression.
5. To add a HAVING clause, click Having.

   The Having Condition window appears.

   
   
6. Define the expression that a column must include to be grouped and click OK.
7. Click OK on the Group By Expression dialog box.