|Skip Navigation Links|
|Exit Print View|
|Oracle Java CAPS Data Integrator User's Guide Java CAPS Documentation|
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.
The Properties panel appears.
The Group By Expression dialog box appears.
Note - The Group By Expression option does not affect Upsert or Delete statements.
The Having Condition window appears.