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