Create Table and Build Models

tell me more icon Tell me more.

The output of the join node is a data flow. If you perform a complex transformation such as a join, saving the result of the transformation as a table results in faster subsequent operations.

Follow these steps to create a table:

  1. Create a Create Table or View node: In the Component Palette, click the Data section, and left-click Create Table. Move the cursor to the workflow and click again.

  2. Right-click JoinData, select Connect, and connect JoinData to the create table node.

  3. Double-click the create table node. In the Edit Create Table or View Node dialog, name the output table FAST_TABLE.
    tell me more icon Tell me more about what I see in the GUI.
    The name of the Create Table node changes to FAST_TABLE, the name of the output table.

  4. Right-click FAST_TABLE and select Run to create the table.

Now use FAST_TABLE as a data source to build classification models:

  1. Create a Classification node: In the Component Palette, click the Models section, and left-click Classification. Move the cursor to the workflow and click again. Name the classification build node PredictGender.

  2. Right-click FAST_TABLE, select Connect and connect the table to PredictGender.

  3. The Edit Classification Node dialog opens. Select CUST_GENDER as the target. Click OK.

  4. Right-click PredictGender and select Run.

When the execution of PredictGender finishes, you have built and tested four classification models. You can view and compare the models. If you view the models, they show how they tie together the sales data (aggregated data) and the customer demographic data as part of the analysis.

tell me more icon Tell me more.