Arguments - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Argument Category Description
Method Required Specifies one or more statistical methods to use to scale the data set. For method values and descriptions, refer to 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 Required Specifies the input table columns that contain the attribute values of the samples. The attribute values must be numeric values 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. The default value is 'false' (each input column is scaled separately).
Accumulate Optional Specifies the input table columns to copy to the output table. By default, the function copies no input table columns 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. The 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 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.