TD_OneHotEncodingFit Syntax Elements - Teradata® Database
Database Analytic Functions
Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™
Introduction to Teradata Vantage
Advanced SQL Engine Analytic Functions Overview
Usage Notes
Function Syntax Descriptions
Column Specification Syntax Elements
Functions Ignore Disallowed Syntax Elements
Input Table Schemas
Terminology
Displaying Online Help for Advanced SQL Engine Analytic Functions
BC/BCE Timestamps
Workload Management Configuration for Advanced SQL Engine Analytic Functions
AA 7.00 Usage Notes
AA 7.00 Limitations
AA 7.00 Model Tables
Analytic Functions on Advanced SQL Engine and Aster Database
Loading Aster Tables to Advanced SQL Engine Using load_to_teradata
Loading Aster Tables to Advanced SQL Engine Using ODBC
Installing Teradata Parallel Transporter Base
Setting Up the Aster Driver on the Client
Writing the tpt Script
Writing the JobVariablesFile
Running the tpt Script
Example: Loading Aster Table to Advanced SQL Engine Using ODBC
Aster Model Table Schemas
Advanced SQL Engine Analytic Functions
Antiselect (SQL Engine)
Antiselect Syntax
Antiselect Syntax Elements
Antiselect Input
Antiselect Output
Antiselect Examples
Antiselect Example: No Column Ranges
Antiselect Example: Column Range
Attribution (SQL Engine)
Attribution Syntax
Attribution Syntax Elements
Attribution Input
Model Specification
Attribution Output
Attribution Example: Model Assigns Weights to Events and Channels
DecisionForestPredict (SQL Engine)
DecisionForestPredict Syntax
DecisionForestPredict Syntax Elements
DecisionForestPredict Input
DecisionForestPredict Output
DecisionForestPredict Examples
DecisionForestPredict Example: Specify Column Names
DecisionForestPredict Example: Specify Column Range, OutputProb, Responses
DecisionTreePredict (SQL Engine)
DecisionTreePredict Syntax
DecisionTreePredict Syntax Elements
DecisionTreePredict Input
DecisionTreePredict Output
DecisionTreePredict Examples
DecisionTreePredict Examples Input
DecisionTreePredict Example: Apply Model to Test Data
DecisionTreePredict Example: OutputProb, Responses
GLMPredict (SQL Engine)
GLMPredict Syntax
GLMPredict Syntax Elements
GLMPredict Input
GLMPredict Output
GLMPredict Examples
GLMPredict Example: Logistic Distribution Prediction
GLMPredict Example: Gaussian Distribution Prediction
GLMPredict Example: Casting Input Column to VARCHAR
MovingAverage (SQL Engine)
Weighted Moving Average
Triangular Moving Average
Simple Moving Average
Modified Moving Average
Exponential Moving Average
Cumulative Moving Average
MovingAverage Syntax
MovingAverage Syntax Elements
MovingAverage Input
MovingAverage Output
MovingAverage Examples
MovingAverage Examples Input
MovingAverage Example: Cumulative Moving Average
MovingAverage Example: Exponential Moving Average
MovingAverage Example: Modified Moving Average
MovingAverage Example: Simple Moving Average
MovingAverage Example: Triangular Moving Average
MovingAverage Example: Weighted Moving Average
NaiveBayesPredict (SQL Engine)
NaiveBayesPredict Syntax
NaiveBayesPredict Syntax Elements
NaiveBayesPredict Input
NaiveBayesPredict Output
NaiveBayesPredict Example
NaiveBayesTextClassifierPredict (SQL Engine)
NaiveBayesTextClassifierPredict Syntax
NaiveBayesTextClassifierPredict Syntax Elements
NaiveBayesTextClassifierPredict Input
NaiveBayesTextClassifierPredict Output
NaiveBayesTextClassifierPredict Examples
NaiveBayesTextClassifierPredict Example: TopK Specified
NaiveBayesTextClassifierPredict Example: Responses Specified
NGramSplitter (SQL Engine)
NGramSplitter Syntax
NGramSplitter Syntax Elements
NGramSplitter Input
NGramSplitter Output
NGramSplitter Examples
NGramSplitter Example: Omit Accumulate
NGramSplitter Example: Specify Accumulate
nPath® (SQL Engine)
nPath Syntax
nPath Syntax Elements
nPath Input
nPath Output
nPath Symbols
LAG and LEAD Expressions in Symbol Predicates
LAG Expression Syntax
LAG and LEAD Expression Rules
LAG and LEAD Expressions Example: Alias for Input Query
LAG and LEAD Expressions Example: No Alias for Input Query
nPath Patterns
nPath Greedy Pattern Matching
nPath Filters
nPath Filters Example
nPath Results
nPath Results Examples
nPath Results Example: FIRST, LAST_NOTNULL, MAX_CHOOSE, and MIN_CHOOSE
nPath Results Example: FIRST and Three Forms of ACCUMULATE
nPath Results Example: FIRST, Three Forms of ACCUMULATE, COUNT, and NTH
nPath Results Example: Combine Values from One Row with Values from the Next Row
nPath Results Example: Hindi Input, ACCUMULATE FIRST_NOTNULL
nPath Results Example: Hindi Input, ACCUMULATE DISTINCT and CDISTINCT
nPath Differences on Aster Database and Advanced SQL Engine
nPath Examples
Symbols and Symbol Predicates That Examples Use
nPath ClickStream Data Examples
nPath Range-Matching Examples
nPath Range-Matching Example: Accumulate Pages Visited in Each Session
nPath Range-Matching Example: Find Sessions That Start at Home Page and Visit Page1
nPath Range-Matching Example: Find Paths to Checkout Page for Purchases Over $200
nPath Range-Matching Example: Use OVERLAPPING Mode
nPath Range-Matching Example: Find First Product with Multiple Referrers in Any Session
nPath Range-Matching Example: Find Data for Sessions That Checked Out 3-6 Products
nPath Range-Matching Example: Find Data for Sessions That Checked Out at Least 3 Products
nPath Range-Matching Example: Multiple Partitioned Input Tables and Dimension Input Table
Pack (SQL Engine)
Pack Syntax
Pack Syntax Elements
Pack Input
Pack Output
Pack Examples
Pack Examples Input
Pack Example: Default Options
Pack Example: Nondefault Options
Sessionize (SQL Engine)
Sessionize Syntax
Sessionize Syntax Elements
Sessionize Input
Sessionize Output
Sessionize Example
StringSimilarity (SQL Engine)
StringSimilarity Syntax
StringSimilarity Syntax Elements
StringSimilarity Input
StringSimilarity Output
StringSimilarity Examples
StringSimilarity Example: Specify Column Names
StringSimilarity Example: Specify Column Ranges
SVMSparsePredict (SQL Engine)
SVMSparsePredict Syntax
SVMSparsePredict Syntax Elements
SVMSparsePredict Input
SVMSparsePredict Output
Calculation of prob_response and predict_confidence
SVMSparsePredict Example
Unpack (SQL Engine)
Unpack Syntax
Unpack Syntax Elements
Unpack Input
Unpack Output
Unpack Examples
Unpack Example: Delimiter Separates Virtual Columns
Unpack Example: No Delimiter Separates Virtual Columns
Unpack Example: More Input Columns than Output Columns
Unpack Example: IgnoreInvalid ('true') with Trailing Special Characters
Data Cleaning Functions
TD_ConvertTo
TD_ConvertTo Syntax
TD_ConvertTo Syntax Elements
TD_ConvertTo Input
TD_ConvertTo Output
TD_ConvertTo Example
TD_GetRowsWithoutMissingValues
TD_GetRowsWithoutMissingValues Syntax
TD_GetRowsWithoutMissingValues Syntax Elements
TD_GetRowsWithoutMissingValues Input
TD_GetRowsWithoutMissingValues Output
TD_GetRowsWithoutMissingValues Example
TD_OutlierFilterFit
TD_OutlierFilterFit Syntax
TD_OutlierFilterFit Syntax Elements
TD_OutlierFilterFit Input
TD_OutlierFilterFit Output
TD_OutlierFilterFit Example
TD_OutlierFilterTransform
TD_OutlierFilterTransform Syntax
TD_OutlierFilterTransform Input
TD_OutlierFilterTransform Output
TD_OutlierFilterTransform Example
TD_SimpleImputeFit
TD_SimpleImputeFit Syntax
TD_SimpleImputeFit Syntax Elements
TD_SimpleImputeFit Input
TD_SimpleImputeFit Output
TD_SimpleImputeFit Example
TD_SimpleImputeTransform
TD_SimpleImputeTransform Syntax
TD_SimpleImputeTransform Input
TD_SimpleImputeTransform Output
TD_SimpleImputeTransform Example
Data Exploration Functions
TD_CategoricalSummary
TD_CategoricalSummary Syntax
TD_CategoricalSummary Syntax Elements
TD_CategoricalSummary Input
TD_CategoricalSummary Output
TD_CategoricalSummary Example
TD_ColumnSummary
TD_ColumnSummary Syntax
TD_ColumnSummary Syntax Elements
TD_ColumnSummary Input
TD_ColumnSummary Output
TD_ColumnSummary Example
TD_GetRowsWithMissingValues
TD_GetRowsWithMissingValues Syntax
TD_GetRowsWithMissingValues Syntax Elements
TD_GetRowsWithMissingValues Input
TD_GetRowsWithMissingValues Output
TD_GetRowsWithMissingValues Example
TD_Histogram
TD_Histogram Syntax
TD_Histogram Syntax Elements
TD_Histogram Input
TD_Histogram Output
TD_Histogram Example
TD_QQNorm
TD_QQNorm Syntax
TD_QQNorm Syntax Elements
TD_QQNorm Input
TD_QQNorm Output
TD_QQNorm Example
TD_UnivariateStatistics
TD_UnivariateStatistics Syntax
TD_UnivariateStatistics Syntax Elements
TD_UnivariateStatistics Input
TD_UnivariateStatistics Output
TD_UnivariateStatistics Example
TD_WhichMax
TD_WhichMax Syntax
TD_WhichMax Syntax Elements
TD_WhichMax Input
TD_WhichMax Output
TD_WhichMax Example
TD_WhichMin
TD_WhichMin Syntax
TD_WhichMin Syntax Elements
TD_WhichMin Input
TD_WhichMin Output
TD_WhichMin Example
Feature Engineering Transform Functions
TD_BinCodeFit
TD_BinCodeFit Syntax
TD_BinCodeFit Syntax Elements
TD_BinCodeFit Input
TD_BinCodeFit Output
TD_BinCodeFit Example
TD_BinCodeTransform
TD_BinCodeTransform Syntax
TD_BinCodeTransform Syntax Elements
TD_BinCodeTransform Input
TD_BinCodeTransform Output
TD_BinCodeTransform Example
TD_FunctionFit
TD_FunctionFit Syntax
TD_FunctionFit Input
TD_FunctionFit Output
TD_FunctionFit Example
TD_FunctionTransform
TD_FunctionTransform Syntax
TD_FunctionTransform Syntax Elements
TD_FunctionTransform Input
TD_FunctionTransform Output
TD_FunctionTransform Example
TD_OneHotEncodingFit
TD_OneHotEncodingFit Syntax
TD_OneHotEncodingFit Syntax Elements
TD_OneHotEncodingFit Input
TD_OneHotEncodingFit Output
TD_OneHotEncodingFit Example
TD_OneHotEncodingTransform
TD_OneHotEncodingTransform Syntax
TD_OneHotEncodingTransform Syntax Elements
TD_OneHotEncodingTransform Input
TD_OneHotEncodingTransform Output
TD_OneHotEncodingTransform Example
TD_PolynomialFeaturesFit
TD_PolynomialFeaturesFit Syntax
TD_PolynomialFeaturesFit Syntax Elements
TD_PolynomialFeaturesFit Input
TD_PolynomialFeaturesFit Output
TD_PolynomialFeaturesFit Example
TD_PolynomialFeaturesTransform
TD_PolynomialFeaturesTransform Syntax
TD_PolynomialFeaturesTransform Syntax Elements
TD_PolynomialFeaturesTransform Input
TD_PolynomialFeaturesTransform Output
TD_PolynomialFeaturesTransform Example
TD_RowNormalizeFit
TD_RowNormalizeFit Syntax
TD_RowNormalizeFit Syntax Elements
TD_RowNormalizeFit Input
TD_RowNormalizeFit Output
TD_RowNormalizeFit Example
TD_RowNormalizeTransform
TD_RowNormalizeTransform Syntax
TD_RowNormalizeTransform Syntax Elements
TD_RowNormalizeTransform Input
TD_RowNormalizeTransform Output
TD_RowNormalizeTransform Example
TD_ScaleFit
TD_ScaleFit Syntax
TD_ScaleFit Syntax Elements
TD_ScaleFit Input
TD_ScaleFit Output
TD_ScaleFit Example
TD_ScaleTransform
TD_ScaleTransform Syntax
TD_ScaleTransform Syntax Elements
TD_ScaleTransform Input
TD_ScaleTransform Output
TD_ScaleTransform Example
Feature Engineering Utility Functions
TD_FillRowID
TD_FillRowID Syntax
TD_FillRowID Syntax Elements
TD_FillRowID Input
TD_FillRowID Output
TD_FillRowID Example
TD_NumApply
TD_NumApply Syntax
TD_NumApply Syntax Elements
TD_NumApply Input
TD_NumApply Output
TD_NumApply Example
TD_RoundColumns
TD_RoundColumns Syntax
TD_RoundColumns Syntax Elements
TD_RoundColumns Input
TD_RoundColumns Output
TD_RoundColumns Example
TD_StrApply
TD_StrApply Syntax
TD_StrApply Syntax Elements
TD_StrApply Input
TD_StrApply Output
TD_StrApply Example
Hypothesis Testing Functions
Hypothesis Test Components
Hypothesis Test Types
TD_ChiSq
TD_ChiSq Syntax
TD_ChiSq Syntax Elements
TD_ChiSq Input
TD_ChiSq Output
TD_ChiSq Example
TD_FTest
TD_FTest Syntax
TD_FTest Syntax Elements
TD_FTest Input
TD_FTest Output
TD_FTest Examples
TD_FTest Example: Specify Two Sample Columns
TD_FTest Example: Specify Two Sample Variances
TD_ZTest
TD_ZTest Syntax
TD_ZTest Syntax Elements
TD_ZTest Input
TD_ZTest Output
TD_ZTest Example
How to Read Syntax
Additional Information
Changes and Additions
Teradata Links
Related Documentation
IsInputDense
Specify whether the input is in dense format.
TargetColumn
[Required with IsInputDense ('true'), disallowed otherwise.] Specify the name of the InputTable column of categorical values.
CategoricalValues
[Required with IsInputDense ('true'), disallowed otherwise.] Specify one or more categorical values in target_column to encode in one-hot form.
OtherColumnName
[Optional with IsInputDense ('true'), disallowed otherwise.] Specify a category name for values that CategoricalValues does not specify (categorical values not to encode in one-hot form).
Default: 'other'
AttributeColumn
[Required with IsInputDense ('false'), disallowed otherwise.] Specify the name of the InputTable column of attributes.
ValueColumn
[Required with IsInputDense ('false'), disallowed otherwise.] Specify the name of the InputTable column of attribute values.
TargetAttributes
[Required with IsInputDense ('false'), disallowed otherwise.] Specify one or more attributes to encode in one-hot form. Every target_attribute must be in attribute_column .
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 n th other_attribute corresponds to the n th target_attribute .