Scale Example 3: Use Training Data to Scale Test Data - Teradata Vantage

This example creates statistics using ScaleMap on a training data set and then uses these statistics to scale a similar test data set.

Input

• Training data: scale_housing, as in Scale Example 1: ScaleMethod ('midrange')
• Test data: scale_housing_test

SQL Call to Create Statistics Table from Training Data

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

SQL Call to Scale Test Data

SELECT * FROM Scale (
  ON scale_housing_test AS "input" PARTITION BY ANY
  ON scale_stat AS STATISTIC DIMENSION
  USING
  ScaleMethod ('midrange')
  Accumulate ('id')
) AS dt;

Output