Use a Join node to combine the aggregated sales data and the customer data to create a data source for building models.
Follow these steps to create the join:
In the Component Palette, click the Transforms section, and
left-click Join. Move the cursor to the workflow and click again. Name the node JoinData
.
Right-click CUSTOMERS
, select Connect, and connect CUSTOMERS
to JoinData
.
Right-click AggregateSALES
, select Connect, and connect CUSTOMERS
to JoinData
.
Double-click JoinData
. The Edit Join Node dialog opens.
Click . The Edit Join Column Dialog opens.
Select CUSTOMERS
as Source 1 and AggregateSALES
as Source 2.
Select CUST_ID
in Source 1 and in Source 2.
Click Add to add CUST_ID
to Join Columns. Note that the dialog determines that the Join Type is Inner.
Tell me more about what I see in the GUI.
Click OK to return to Edit Join Node, and then click OK again to complete the join specification.
Right-click JoinData
and select Run to create the join.
The
Next step is to create a table and build classification models.
Copyright © 2011, 2012, Oracle. All rights reserved.