Scale Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™
ScaleMethod
Specify one or more statistical methods to use to scale the data set. For method values and descriptions, see Location and Scale for Statistical Methods.
If you specify multiple methods, the output table includes the column scalemethod (which contains the method name) and a row for each input-row/method combination.
GlobalScale
[Optional] Specify whether all InputTable columns are scaled to the same location and scale. For a description of location and scale and the values that are used with each ScaleMethod, see Location and Scale for Statistical Methods.
Default: 'false' (Each InputTable column is scaled separately.)
TargetColumns
[Optional] Specify the InputTable columns that contain the values to scale. The columns must contain numeric values between -1e308 and 1e308.
Default: All columns of the Statistic table (the output of the ScaleMap function in the Scale syntax) except stattype
Accumulate
[Optional] Specify the InputTable columns to copy to the output table.
Multiplier
[Optional] Specify one or more multiplying factors to apply to the input variables—multiplier in this formula:

X' = intercept + multiplier * (X - location)/scale

If you specify only one multiplier, it applies to all columns specified by the TargetColumns syntax element. If you specify multiple multiplying factors, each multiplier applies to the corresponding input column. For example, the first multiplier applies to the first column specified by the TargetColumns syntax element, the second multiplier applies to the second input column, and so on.

Default: multiplier is 1.

Intercept
[Optional] Specify one or more addition factors incrementing the scaled results—intercept in this formula:

X' = intercept + multiplier * (X - location)/scale

If you specify only one intercept, it applies to all columns specified by the TargetColumns syntax element. If you specify multiple addition factors, each intercept applies to the corresponding input column.
This is the syntax of intercept:
[-]{number | min | mean | max }

where min, mean, and max are the scaled global minimum, mean, and maximum values of the corresponding columns.

This is the formula for computing the scaled global minimum:

scaledmin = (minX - location)/scale

The formulas for computing the scaled global mean and maximum are analogous to the preceding formula. For example, if intercept is '- min' and multiplier is 1, this is the formula for computing the scaled result X' from the original value X:

X' = -scaledmin + 1 * (X - location/scale)

Default: intercept is 0.