TD_ORDINALENCODINGFIT ( ON { table | view | (query) } AS InputTable [ ON { table | view | (query) } AS CategoryTable Dimension ] [ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable (output_table_name) ] USING TargetColumn ({'target_column' | 'target_column_range'}[,...]) [{ Approach ('LIST') { Categories ('category'[,...]) [ OrdinalValues (ordinal_value[,...]) ] | TargetColumnNames ('targetcolnames_column') CategoriesColumn ('category_column') [ OrdinalValuesColumn ('ordinalvalue_column') ] } | Approach ('AUTO') }] [ StartValue ({ start_value | start_value_i, ... }) ] [ DefaultValue ({ default_value | default_value_i, ... }) ] )
You can call this function from:
- The FROM clause of a SELECT statement
- As part of a CREATE TABLE statement
- As part of a CREATE VIEW statement