TD_DFFT2 Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

The result matrix is a matrix with the same content type as the original MATRIX_SPEC. A univariate input returns a univariate output, and a multivariate input returns a multivariate output.

RETURNS TABLE Schema

In the following table, dominant_payload_name depends on its content. If content is COMPLEX or MULTIVAR_COMPLEX, then this is the payload name associated with the complex components in rectangular form. If CONTENT is AMPL_PHASE or MULTIVAR_AMPL_PHASE, then this the payload name is associated with the amplitude component, and the content is in amplitude and phase number pairs. If content is REAL or MULTIVAR_REAL, then this is the payload name.

Name Data Type Description
derived-matrix-identifier Varies The resultant series identifier inherited from the SERIES_ID.
ROW_I INTEGER or FLOAT Ordering row for ordered result sets.
COLUMN_I INTEGER or FLOAT Ordering column for ordered result sets.
AMPLITUDE_ dominant_payload_name FLOAT Fourier Amplitude coefficient corresponding to ROW_I index.
Only output with the following output settings:
  • CONTENT(AMPL_PHASE_DEGREES)
  • CONTENT(AMPL_PHASE_RADIANS)
  • CONTENT(AMPL_PHASE)
  • CONTENT(MULTIVAR_AMPL_PHASE_DEGREES)
  • CONTENT(MULTIVAR_AMPL_PHASE_RADIANS)
  • CONTENT(MULTIVAR_AMPL_PHASE)
PHASE_dominant_payload_name FLOAT

Fourier phase coefficient corresponding to ROW_I index.

Only output with the following output settings:
  • CONTENT(AMPL_PHASE_DEGREES)
  • CONTENT(AMPL_PHASE_RADIANS)
  • CONTENT(AMPL_PHASE)
  • CONTENT(MULTIVAR_AMPL_PHASE_DEGREES)
  • CONTENT(MULTIVAR_AMPL_PHASE_RADIANS)
  • CONTENT(MULTIVAR_AMPL_PHASE)
REAL_dominant_payload_name FLOAT

Fourier real coefficient corresponding to ROW_I index.

Only output when OUTPUT_FMT(CONTENT(COMPLEX)).

IMAGINARY_dominant_payload_name FLOAT

Fourier imaginary coefficient corresponding to ROW_I index.

Only output when OUTPUT_FMT(CONTENT(COMPLEX)).