Multi-Record Case Table Format

Use this dialog to specify the mapping from the input table to the predefined format for a multiple record case (transactional) table.

You must specify the following:

For each choice, valid columns are displayed in the dropdown list; select the items.

After you have specified the mappings, click OK to proceed. The wizard validates that you have selected different values for the selections.

Datatype Requirements

The required datatypes for Sequence Id, Attribute Name, and Value depend on the operation you are performing as follows:

For information about when to use Multi-Record Case format, see Table Formats.

You can specify that the data be Single Metric by clicking the checkbox. The default is to not check the box. See Single Metric for a description of this selection.

When you are done, click the OK button. The wizard validates that a column was selected for each value and that no two selections are the same. If validation fails, the wizard explains the problem.

This format is also called transactional format or multiple record per case format.

Attribute Name Requirements

Attribute names must satisfy the requirements for non quoted identifiers, as described in Names of Data Mining Objects.

Restriction: Attribute Name should be no longer than 30 characters. Oracle Data Mining does not support longer attribute names (that is, VARCHAR2(n) with n>30) in operations such as model building.

Note: The Oracle Data Mining data mining server ignores case in attribute names.

Example

This example illustrates multi-record case format for data used for model building.

Suppose that we have two attributes, HairColor and EyeColor. Suppose that the attributes are coded as follows:

If the first instance of the attribute "HairColor" is red (1), you would specify

If the second instance of the attribute "HairColor" is brown (2), you would specify

You can associate other attributes (for example, "EyeColor") with the same Sequence Id. For example, if the first instance of EyeColor is blue (4):