TD_ScaleTransformの例 - Advanced SQL Engine - Teradata Database

• InputTable: input_table (TD_ScaleFitの例と同様)
• FitTable: scaleFitOut (TD_ScaleFitの例によって出力)

SQL呼び出し

SELECT * FROM TD_scaleTransform (
  ON scale_input_table AS InputTable
  ON scaleFitOut AS FitTable DIMENSION
  USING
  Accumulate ('passenger')
) AS dt ORDER BY 1;

出力

passenger fare        
 --------- ------------------ 
        97 0.363855214723926
       488 0.303067484662577
       505 1
       631 0.306748466257669
       873 0