7.00.02 - PartitionScale Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17
Method
Specifies one or more statistical methods to use to scale the data set. For method values and descriptions, see the table "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.

MissValue
[Optional] Specifies how the PartitionScale function is to process NULL values in input:
  • KEEP (Default)

    Keep NULL values.

  • OMIT

    Ignore any row that has a NULL value.

  • ZERO

    Replace each NULL value with zero.

  • LOCATION

    Replace each NULL value with its location value.

InputColumns
Specifies the input table columns that contain the values to scale. The columns must contain numeric values must between -1e308 and 1e308. If a value is outside this range, the function treats it as infinity.
Global
[Optional] Specifies whether all input columns are scaled to the same location and scale. Default: 'false' (each input column is scaled separately).
Accumulate
[Optional] Specifies the input table columns to copy to the output table.
Tip: To identify the sequences in the output, specify the partition columns in this argument.
Multiplier
[Optional] 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 columns specified by the InputColumns argument.

If you specify multiple multiplying factor, each multiplier applies to the corresponding input column. For example, the first multiplier applies to the first column specified by the InputColumns argument, the second multiplier applies to the second input column, and so on. Default: multiplier is 1.

Intercept
[Optional] 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 scaled global minimum, maximum, mean values of the corresponding columns.

The formula for computing the scaled global minimum is:

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, the formula for computing the scaled result X' is:

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

Default: intercept is 0.