TD_OrdinalEncodingTransform Input - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™

InputTable Schema

Column Data Type Description
target_column CHAR or VARCHAR CHARACTER SET LATIN/UNICODE Columns to be encoded.

FitTable Schema

Column Data Type Description
TD_ColumnName_ORDFIT VARCHAR CHARACTER SET UNICODE Column which contains the names of the target columns.
TD_Category_ORDFIT VARCHAR CHARACTER SET UNICODE Column which contains the category values along with TD_CategoryCount and TD_OtherCategory for each of the target columns.
TD_Value_ORDFIT INTEGER Column which contains the ordinal values for each category and for each target column.
TD_Index_ORDFIT SMALLINT Column which contains the index of the target columns.
Target_column_1.….Target_column_N Any Column names copied to fit output, needed in the Transform function.