TD_DWT Examples | Digital Signal Processing | Teradata Vantage - TD_DWT Examples - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

Example: TD_DWT with a Known Wavelet

EXECUTE FUNCTION
INTO VOLATILE ART(tmpTable)
  TD_DWT
  (
    SERIES_SPEC (
      TABLE_NAME (dataTable1),
      SERIES_ID (id),
      ROW_AXIS (SEQUENCE (rowi)),
      PAYLOAD (
      FIELDS (v),
      CONTENT (REAL)
    ) ),
    FUNC_PARAMS (
      WAVELET ('haar')
    )
);

Example: TD_DWT with a Custom Filter

EXECUTE FUNCTION
INTO VOLATILE ART(tmpTable)
  TD_DWT
  (
    SERIES_SPEC (
      TABLE_NAME (dataTable1),
      SERIES_ID (id),
      ROW_AXIS (SEQUENCE (rowi)),
      PAYLOAD (
      FIELDS (v),
      CONTENT (REAL)
   )
  ),
  SERIES_SPEC (
    TABLE_NAME (filterTable),
    SERIES_ID (id),
    ROW_AXIS (SEQUENCE (seq)),
    PAYLOAD (
    FIELDS (lo, hi),
    CONTENT (MULTIVAR_REAL)
    )
  )
  WHERE id = 1,
  INPUT_FMT (INPUT_MODE (MANY2ONE))
);