Optional Syntax Elements for TD_OneHotEncodingFit - 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™
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.