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.