TD_DWT Output - 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

The TD_DWT function returns a primary result set which corresponds to the final level of decomposition. There are no additional layers of data being generated.

Display the RETURNS TABLE with a SELECT statement.
RETURNS TABLE Schema
Name Data Type Description
ROW_I BIGINT Index of the decomposed value.
A_prefix FLOAT Transformed approximation part. This column is not generated if PART parameter is specified to only generate detail part. Default is A_PayloadName. PayloadName is a payload column name.
D_prefix FLOAT Transformed detail part. This column is not generated if PART parameter is specified to only generate approximation part.Default is D_PayloadName. PayloadName is a payload column name.