Basic Syntax
IDMMX.FindDeviations(deviationsView,
inputTable)
You can choose to specify optional parameters in addition to the basic syntax.
Parameters
With the FindDeviations procedure, you must specify the following parameters:
- deviationsView
- The name of the view that you want to build.
This parameter is of type VARCHAR and has a maximum character size of 240.
- inputTable
- The name of the input table or the input view.
The columns of the input table that are unlikely to be useful to create a model are ignored by the Easy Mining procedure. For example, key columns are ignored.
This parameter is of type VARCHAR and has a maximum character size of 257.
Output
The FindDeviations procedure creates a model and a view. The model is stored in the table IDMMX.CLUSTERMODELS under the same name as the generated view. If a model with the same name already exists, the previous model is replaced with the new model. If a view with the same name already exists, the previous view is replaced with the new view.
- DEV_DEGREE
- This column indicates the degree of deviation for each record. The degree of deviation is a number greater than 1. High numbers represent a high degree of deviation.
- CLUSTER_ID
- This column identifies the clusters that these records belong to.
The small clusters are of interest to you because you are looking for unusual behavior. The cluster ID helps you to interpret the deviation because the typical characteristics of a cluster characterize the deviation.
To explore the clusters in detail, you can use the table function DM_getClusters or the visualizer in the Design Studio.
