Edit Relationship

Define the join of data to the case table.

There are examples of how to specify joins in the Oracle Data Mining Tutorial.

Map key columns for the join; you must map a key column in the case table to a key column in the related table. The key column mappings consist of one or more mappings of Case Table Column to Related Table Column. To create the first mapping or to edit an existing mapping, click the entry in a column. The wizard displays a list of attributes; pick the desired attribute. You may need to specify more than one column to establish uniqueness. To create a new mapping, click New and select the attributes to map. To delete an existing mapping, select the mapping and click Delete.

Next indicate the Relationship Type. There are two choices for relationship type:

Note: Decision Tree does not permit input data with transactional data joined in. If you are creating a build activity for a Decision Tree model, you are not permitted to select One to Many.

If the relationship is One to One, specify the columns to join.

If the relationship is One to Many, click New to define a transactional column mapping. To edit an existing mapping, select the mapping, and click Edit. To delete an existing mapping, select the mapping, and click Delete. Clicking New or Edit launches a dialog where you define or edit the mapping.

Click Next to proceed.