Build Model Procedure for Models Without Test

This procedure is generated from an activity that successfully builds a model using the algorithms that do not have a test step in their activity, that is, Anomaly Detection, Attribute Importance, k-Means, O-Cluster, and Feature Extraction algorithms. All parameters are initialized to the default values that were used by the build activity. If you use input parameters that are not the default parameters, you must ensure the new data is compatible with the original data that was used by the activity.

Syntax

PROCEDURE build_procedure_name(
           case_table    IN VARCHAR2 DEFAULT activity_default,
           table_1       IN VARCHAR2 DEFAULT activity_default,
           table_n       IN VARCHAR2 DEFAULT activity_default,
           model_name    IN VARCHAR2 DEFAULT activity_default,
           feature_table IN VARCHAR2 DEFAULT activity_default,
           mapping_table IN VARCHAR2 DEFAULT activity_default,
           drop_model    IN BOOLEAN DEFAULT user_defined);

Parameters and Defaults

The procedure has two kinds of defaults:

Table 1 Build Procedure Parameters

Parameter Description
build_procedure_name The name specified for the procedure when the code was generated.
table_1 The name of the first additional table. The name is in the form schema_name.table_name. This parameter is optional.
table_n The name of the n-th additional table. The name is in the form schema_name.table_name. This parameter is optional.
model_name The name of the model created by the procedure; 25 or fewer characters in length.
mapping_table Feature frequencies table generated by the text transform. Utilized by the apply and test procedures to regenerate a similar text transformation.
feature_table Feature ID to text mapping table generated by the text transform. Can be used to translate model detail output containing columns affected by a text transformation.
drop_model A flag indicating whether to drop the model if it already exists. The value of this flag was specified when the code was generated.

Usage Notes

This procedure includes all necessary data preparation, data transformations, and model build settings. The procedure creates a model. If the model already exists and drop_model is set to FALSE, the procedure will raise an exception to the caller and exit.

The feature table generated by the Build procedure is used in the Apply procedure.

You can supply a feature_table name different from the default name, but you must supply the same name in both Build and Apply procedures.