Use an aggregate node to transform the data in SALES so that it is summarized (aggregated) on a per-customer basis.
Follow these steps to create the aggregation:
In the Component Palette, click the Transforms section, and
left-click Aggregate. Move the cursor to the workflow and click again. Name the node AggregateSALES
.
Right-click SALES
, select Connect, and connect SALES
to AggregateSALES
.
Double-click AggregateSALES
. The Edit Aggregate Node dialog opens.
At the top of the dialog, click Edit to select a Group By column. Edit Group By launches. Check that Type is Column. Move CUST_ID
from Available Attributes to Selected Attributes. Click OK.
Back in the Edit Aggregate Node dialog, click to launch the Define Aggregation wizard.
Follow these steps to define the aggregation:
QUANTITY_SOLD
and AMOUNT_SOLD
from Available Attributes to Selected Attributes; click Next.PROD_ID
from Available Attributes to Selected Attributes;
click Next.Back in the Edit Aggregation dialog, click OK.
Right-click AggregateSALES
and select Run to run the aggregation.
The
Next step is to join the aggregated data to the customer data.
Copyright © 2011, 2012, Oracle. All rights reserved.