ScaleMap Input - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input Table Schema

Column Data Type Description
target_column SMALLINT, INT, BIGINT, NUMERIC, or DOUBLE PRECISION [Column appears once for each specified target_column.] Contains numeric values.

Invalid Input Data Handling

  • If the input table has infinity or NaN values, the input is invalid. The Scale and ScaleByPartition functions do not process these values, but the ScaleMap function counts the values in each column, including invalid values. The count of input values is available in the output of the ScaleSummary function.
  • If a column contains only invalid input values, the data in this column is not modified.
  • If a sequence has only one unique value, the result of the USTD, STD, RANGE, and MIDRANGE operations are NaN values because the function cannot calculate the scale.