TD_​ScaleFit

fastpath function to generate required statistics and scaling parameters to be used by TD_ScaleTransform for scaling the input data.

Options

GlobalScale
Specifies whether all input columns are scaled to the same location and scale (using global statistics). The default value is 'false' (each input column is scaled separately).
Intercept (strings seperated by new line)
Specifies one or more addition factors incrementing the scaled results, intercept in the following formula: X' = intercept + multiplier * (X - location)/scale If you specify only one intercept, it applies to all columns specified by the InputColumns argument. If you specify multiple addition factors, each intercept applies to the corresponding input column. The syntax of intercept is: [-]{number | min | mean | max } where min, mean, and max are the global minimum, maximum, mean values in the corresponding columns. The function scales the values of min, mean, and max. For example, if intercept is '- min' and multiplier is 1, the scaled result is transformed to a nonnegative sequence according to this formula, where scaledmin is the scaled value: X' = -scaledmin + 1 * (X - location)/scale The default intercept is 0.
MissValue
Specifies how to process NULL values in input, as follows:KEEP (default): Keep NULL values, ZERO: Replace each NULL value with zero, LOCATION: Replace each NULL value with its location value.
Multiplier (strings seperated by new line)
Specifies one or more multiplying factors to apply to the input variables, multiplier in the following formula: X' = intercept + multiplier * (X - location)/scale. If you specify only one multiplier, it applies to all TargetColumns. If you specify multiple multiplying factors, each multiplier applies to the corresponding TargetColumn. For example, the first multiplier applies to the first column specified by the TargetColumns argument, the second multiplier applies to the second input column, and so on. The default multiplier is 1.
ScaleMethod (strings seperated by new line)
Specify the ScaleMethod to be used for scaling. If one value is provided, it applies to all target columns. If more than one value is specified, ScaleMethod values applies to TargetColumns values in the order specified by the user.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
TargetColumns
Specifies the input table columns for which scaling parameters and statistics will be generated.
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The relation that contains input data.

Output Ports

Icon
output of TD_ScaleFit

Nodes

Extensions

Links