Scale Example 4: Multiple Methods - Teradata Vantage

This example scales input data using multiple methods—midrange, mean, maxabs, and range—in the same function call.

Input

• Training data: scale_housing, as in Scale Example 1: ScaleMethod ('midrange')
• Test data: tmpScale, created with this statement:

  CREATE MULTISET table tmpScale AS (
    SELECT * FROM ScaleMap (
    ON scale_housing
    USING
    TargetColumns ('[2:6]')
    MissValue ('omit')
    ) AS dt 
  ) WITH DATA;

SQL Call

SELECT * FROM Scale (
  ON scale_housing AS "input" PARTITION BY ANY
  ON tmpScale AS statistic DIMENSION
  USING
  ScaleMethod ('midrange','mean','maxabs','range')
  Accumulate ('id')
) AS dt ORDER BY id, price, lotsize;

Output