Required Syntax Elements for TD_ScaleFit - 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
Specifies the table name, view name or query as an InputTable.
ScaleMethod
Specifies the name of the method to be used for Scaling data.
If you specify only one argument value, it applies to all columns specified by the TargetColumns argument. If you specify multiple argument values, each argument value applies to the corresponding input column. For example, the first argument value applies to the first column specified by the TargetColumns argument, the second argument value applies to the second input column, and so on.
Allowed values: [MEAN, SUM, USTD, STD, RANGE, MIDRANGE, MAXABS, RESCALE]
For the RESCALE method, you must specify whether to apply lower_bound only, upper_bound only, or both lower_bound and upper_bound and corresponding bound values, in the format mentioned in TD_ScaleFit Syntax.
TargetColumns
Specifies the name of the InputTable columns for which to output statistics. The columns must contain numeric data in the range (-1e308, 1e308).
Argument for dense input, disallowed otherwise.
AttributeNameColumn
Specifies the InputTable column that contains the attribute or feature names.
Argument for sparse input, disallowed otherwise.
AttributeValueColumn
Specifies the InputTable column that contains the attribute or feature values.
Argument for sparse input, disallowed otherwise.