TD_OrdinalEncodingTransform Function Example | Teradata Vantage - Example: How to Use TD_OrdinalEncodingTransform - Analytics Database

TD_OrdinalEncodingFit InputTable: OrdEnc_titanic_train

Example: TD_OrdinalEncodingFit SQL Call Using Auto Approach

SELECT * FROM TD_OrdinalEncodingFit (
 ON ordinal_titanic_dataset AS InputTable
 OUT PERMANENT TABLE OutputTable (ordinal_titanic_fit_output)
 USING
 TargetColumn('name','gender','ticket','cabin','embarked')
 Approach ('AUTO')
 StartValue (5, 10, 15, 0, -5)
 DefaultValue (-1, -10, -15, 20, 0)
) AS dt ORDER BY 1,3;

TD_OrdinalEncodingTransform Output Table Using Auto Approach

Example: TD_OrdinalEncodingTransform SQL Call Using Output from TD_OrdinalEncodingFit

SELECT * FROM TD_OrdinalEncodingTransform (
 ON ordinal_titanic_dataset AS InputTable
 ON ordinal_titanic_fit_output as FitTable Dimension
  USING
 Accumulate ('passenger')
) AS dt ORDER BY 1;

TD_OrdinalEncodingTransform Output

 passenger name gender ticket cabin embarked
 --------- ---- ------ ------ ----- --------
        97    8     12     20     2       -4
       488    9     12     17     3       -4
       505   10     11     16     5       -3
       631    6     12     18     1       -3
       873    7     12     19     4       -3
      1000    5     10     15     0       -5