TD_DWT Output - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.