Optional Syntax Elements for TD_OneHotEncodingFit - Analytics Database

Database Analytic Functions
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
ON clause
Accepts the CategoryTable clause.
Applicable for dense input format only.
IsInputDense
Specifies whether the input is dense or sparse.
CategoryTable is meant for dense input format and not for sparse format.
TargetColumnNames
Specifies the CategoryTable column which contains the name of the target columns.
CategoriesColumn
Specifies the CategoryTable column which contains the category values.
CategoryCounts
Specifies the category counts for each of the TargetColumns. The number of values in CategoryCounts must be the same as the number of TargetColumns.
Approach
Specifies whether to determine categories automatically from the input table data (AUTO approach) or the user-provided list (LIST approach).
Default: LIST.
OtherColumnName
[Optional with IsInputDense ('true'), disallowed otherwise.] Specifies the column name for the column representing one-hot encoding for values other than the ones specified in the CategoricalValues argument or CategoryTable or categories found through the Auto approach.
Default: 'other'
  • The number of characters in TargetColumnNames plus the number of characters in other category value must be less than 128 characters.
  • The maximum number of other category value in the OtherColumnName argument is 2018.
OtherAttributeNames
[Optional with IsInputDense ('false'), disallowed otherwise.] For each target_attribute, specify a category name (other_attribute) for attributes that TargetAttributes does not specify. The nth other_attribute corresponds to the nth target_attribute.
  • The number of characters in values specified in the TargetAttributes argument plus the number of characters in values specified in the OtherAttributeNames argument must be less than 128 characters.
  • The number of values passed to the TargetAttributes argument and OtherAttributeNames argument must be equal.