There are two ways to create a transformation list:
The STACK interface in DBMS_DATA_MINING_TRANSFORM.
The STACK interface offers a set of pre-defined transformations that you can apply to an attribute or to a group of attributes. For example, you could specify supervised binning for all categorical attributes.
The SET_TRANSFORM procedure in DBMS_DATA_MINING_TRANSFORM.
The SET_TRANSFORM procedure applies a specified SQL expression to a specified attribute. For example, the following statement appends a transformation instruction for country_id to a list of transformations called my_xforms. The transformation instruction divides country_id by 10 before algorithmic processing begins. The reverse transformation multiplies country_id by 10.
dbms_data_mining_transform.SET_TRANSFORM (my_xforms,
'country_id', NULL, 'country_id/10', 'country_id*10');
The reverse transformation is applied in the model details. If country_id is the target of a supervised model, the reverse transformation is also applied to the scored target.