TD_TargetEncodingFit Output - 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-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

TD_TargetEncodingFit Primary Output Table Schema

The CBM_BETA encoder output schema is as follows:

Column Name Data Type Description Charset MaxValueLen
TD_ColumnName_TEFIT VARCHAR Contains the names of the target column. Unicode 128 characters
TD_Category_TEFIT VARCHAR Contains the category values for each of the target columns. Unicode 128 characters
TD_Alpha_TEFIT REAL Contains the hyperparameter value. Not applicable Not applicable
TD_Beta_TEFIT REAL Contains the hyperparameter value. Not applicable Not applicable
TD_DefaultCategory_TEFIT REAL Contains the default values. Not applicable Not applicable
TD_CategoryCount_TEFIT SMALLINT Contains the count of the categories. Not applicable Not applicable
TD_ColumnIndex_TEFIT SMALLINT Contains the index for the target columns. Not applicable Not applicable
TD_EncoderMethod_TEFIT_CBM_BETA BYTEINT Stores the name of the encoder method. Not applicable Not applicable
target_column_i Same as InputTable Column names copied to fit output. Needed in TD_TargetEncodingTransform function. Not applicable Not applicable

The CBM_DIRICHLET encoder output schema is as follows:

Column Name Data Type Description Charset MaxValueLen
TD_ColumnName_TEFIT VARCHAR Contains the names of the target column. Unicode 128 characters
TD_Category_TEFIT VARCHAR Contains the category values for each of the target columns. Unicode 128 characters
TD_Alpha_k_TEFIT_target_column_i REAL Contains the hyperparameter value. Not applicable Not applicable
TD_DefaultCategory_TEFIT REAL Contains the default values. Not applicable Not applicable
TD_CategoryCount_TEFIT SMALLINT Contains the count of the categories. Not applicable Not applicable
TD_ColumnIndex_TEFIT SMALLINT Contains the index for the target columns. Not applicable Not applicable
TD_EncoderMethod_TEFIT_CBM_DIRICHLET BYTEINT Stores the name of the encoder method. Not applicable Not applicable
TD_NumResponses_TEFIT_K BYTEINT Stores the name of the NumDistinctResponses value. Not applicable Not applicable

The CBM_GAUSSIAN_INVERSE_GAMMA encoder output schema is as follows:

Column Name Data Type Description Charset MaxValueLen
TD_ColumnName_TEFIT VARCHAR Contains the names of the target column. Unicode 128 characters
TD_Category_TEFIT VARCHAR Contains the category values for each of the target columns. Unicode 128 characters
TD_U0_TEFIT REAL Contains the hyperparameter value. Not applicable Not applicable
TD_V0_TEFIT REAL Contains the hyperparameter value. Not applicable Not applicable
TD_Alpha0_TEFIT REAL Contains the hyperparameter value. Not applicable Not applicable
TD_Beta0_TEFIT REAL Contains the hyperparameter value. Not applicable Not applicable
TD_DefaultCategory_TEFIT REAL Contains the default values. Not applicable Not applicable
TD_CategoryCount_TEFIT SMALLINT Contains the count of the categories. Not applicable Not applicable
TD_ColumnIndex_TEFIT SMALLINT Contains the index for the target columns. Not applicable Not applicable
TD_EncoderMethod_TEFIT_CBM_GAUSSIAN_INVERSE_GAMMA BYTEINT Stores the name of the encoder method. Not applicable Not applicable
target_column_i Same as InputTable Column names copied to fit output. Needed in TD_TargetEncodingTransform function. Not applicable Not applicable

TD_TargetEncodingFit Secondary Output Table Schema

The secondary output table will have the same schema as the primary output table.