Data mining — Defining a Table Source operator

Use a Table Source operator to specify a DB2® table to be analyzed in a mining flow.

Before you begin

If the table that you want to use was created in the database after you created the mining flow, select Mining Flow > Refresh database to replicate the table definition from the DB2 catalog into your project workspace.

Procedure

To define a Table Source operator, follow these steps:

On the Palette of the Design Studio, click SQL Warehousing Operators > Sources And Targets > Table source, then click the canvas to place the Table Source operator on the canvas.
After the operator is placed on the canvas, the Table Source wizard is opened.
On the General page of the wizard, specify the following parameters and click Next:
1. Optional: In the Label entry field, you can replace the default name of the Table Source operator with a name of your choice.
  The label name can be of unlimited length, however, on the canvas, it is truncated to 14 characters.
2. Optional: In the Description entry field, you can type a description of unlimited length to record additional information about the operator.
  The description is displayed in the Properties view after the definition of the Table Source operator is completed.
3. Optional: You can specify the location for your table by keeping the default selection SQL execution database or selecting Remote database.
  If you select Remote database, you must specify a JDBC connection to the remote database. Optionally, you can specify the JDBC batch size.
4. Optional: In the Sampling Rate entry field, type a percentage to randomly sample rows in the database table.
5. Select a source table in the Table Selection Dialog by clicking .
  If you know the table name and the schema name, you can type these names in the Table name entry field and in the Schema name entry field.
  
  After you specified a name, this name is displayed in the Source database table field.
On the Where Condition page of the wizard, type a filter condition in the Filter condition entry field and click Next.
For more information, see Where condition operators.

You can also use the SQL Condition Builder to specify a filter condition by clicking .
On the Select List page of the wizard, modify the result columns of the Table Source operator and click Finish.
For more information, see Select list operators.