1.1 - 8.10 - ScaleMap Input - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

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.