DWT Example - Teradata Vantage

This example uses hourly climate data for five cities (Asheville, Greenville, Brownsville, Nashville and Knoxville) on a given day. The data are temperature (in degrees Fahrenheit), pressure (in mbars), and dewpoint (in degrees Fahrenheit). The function creates the coefficient model table and the meta table, which are used as input to the function IDWT.

Input

SQL Call

SELECT * FROM DWT (
  ON ville_climatedata AS InputTable
  OUT TABLE OutputTable (dwt_coef_table)
  OUT TABLE MetaTable (dwt_meta_table)
  USING
  TargetColumns ('temp_f', 'pressure_mbar', 'dewpoint_f')
  SortColumn ('period')
  PartitionColumns ('city')
  Wavelet ('db2')
  WaveletTransformLevel (2)
) AS dt;

Output

Dwt finished successfully!

This query returns the following table:

SELECT * FROM dwt_coef_table ORDER BY city, waveletid, waveletcomponent;

This query returns the following table:

SELECT * FROM dwt_meta_table ORDER BY city;