Optional Syntax Elements for TD_OneHotEncodingFit - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798
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.