Optional Syntax Elements for TD_OneHotEncodingFit - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
ON clause
Accept the CategoryTable clause.
Applicable for dense input format only.
IsInputDense
Specify whether the input is dense or sparse.
CategoryTable is meant for dense input format and not for sparse format.
TargetColumnNames
Specify the CategoryTable column which contains the name of the target columns.
CategoriesColumn
Specify the CategoryTable column which contains the category values.
CategoryCounts
Specify the category counts for each of the TargetColumns. The number of values in CategoryCounts must be the same as the number of TargetColumns.
Approach
Specify 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.] Specify 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.