Scale Example 2: ScaleMethod ('midrange'), Intercept (-min) - Teradata Vantage

This example is like Example 1 except that the Intercept argument has the value -min (where min is the global minimum value). This example also specifies a Multiplier value, but it is the default, as in Example 1.

Input

• input: scale_housing, as in Scale Example 1: ScaleMethod ('midrange')
• statistic: scale2, created with this statement:

  CREATE MULTISET table scale2 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 scale2 AS statistic DIMENSION
  USING
  ScaleMethod ('midrange')
  Accumulate ('id')
  Intercept('-min')
  Multiplier(1)
) AS dt ORDER BY id, price, lotsize;

Output

As explained in the description of the Intercept argument, this is the formula for computing the scaled value X' from the input value X when intercept is -min:

X' = - scaledmin + 1 * (X - location)/scale

This is the formula for computing scaledmin when intercept is -min:

scaledmin = (minX - location)/scale

For example, consider row 1 of the price column in the input table and the following output table: