Use this screen to specify the mapping from the input table to the predefined format for a multiple record case (transactional) table.
You must specify:
For each choice, valid columns are displayed in the dropdown list.
The required data types for Sequence Id, Attribute Name, and Value depend on what operations you are performing:
For information about when to use Multi-Record Case format, see Table Formats.
When you have made the selections, click the OK button. The wizard validates that a column has be selected for each value and that no name is the same. If validation fails, the wizard explains the problem.
This format is also called transactional format or multiple record per case format.
Attribute names must satisfy the requirements for nonquoted identifiers, as described in Names of Data Mining Objects.
RESTRICTION: Attribute Name should be no longer than 30 characters. ODM does not support longer attribute names (that is, VARCHAR2(n) with n>30) in operations such as model building.
Note: The ODM data mining server ignores case in attribute names.
This example illustrates multi-record case format for data used for model building.
Suppose that we have two attributes, HairColor and EyeColor. Suppose that these attributes have been binned as follows:
If the first instance of the attribute "HairColor" is red (Bin 1), you would specify
If the second instance of the attribute "HairColor" is brown (Bin 2), you would specify
You can associate other attributes (for example, "EyeColor") with the same Sequence Id. For example:
For another example, see Data Mining Concepts in Where to Find More Information.
Copyright © 2005, Oracle. All rights reserved.