These two functions can be used to create a new transformation list from the transformations embedded in an existing model.
The GET_MODEL_TRANSFORMATIONS
function returns a list of embedded transformations.
DBMS_DATA_MINING.GET_MODEL_TRANSFORMATIONS ( model_name IN VARCHAR2) RETURN DM_TRANSFORMS PIPELINED;
GET_MODEL_TRANSFORMATIONS
returns a table of dm_transform
objects. Each dm_transform
has these fields
attribute_name VARCHAR2(4000) attribute_subname VARCHAR2(4000) expression CLOB reverse_expression CLOB
The components of a transformation list are transform_rec
, not dm_transform
. The fields of a transform_rec
are described in Table 4-2. You can call GET_MODEL_TRANSFORMATIONS
to convert a list of dm_transform
objects to transform_rec
objects and append each transform_rec
to a transformation list.
DBMS_DATA_MINING.GET_TRANSFORM_LIST ( xform_list OUT NOCOPY TRANSFORM_LIST, model_xforms IN DM_TRANSFORMS);
See Also:
DBMS_DATA_MINING_TRANSFORM
in "Operational Notes" in Oracle Database PL/SQL Packages and Types Reference
DBMS_DATA_MINING_TRANSFORM.SET_TRANSFORM
in Oracle Database PL/SQL Packages and Types Reference
DBMS_DATA_MINING.CREATE_MODEL
in Oracle Database PL/SQL Packages and Types Reference
DBMS_DATA_MINING.GET_MODEL_TRANSFORMATIONS
in Oracle Database PL/SQL Packages and Types Reference