TD_IDFFT2 Syntax Elements - 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
MATRIX_SPEC (TD_DFFT2_RETURNS_TABLE)
A matrix containing Fourier coefficients that is passed in to the TD_IDFFT2.

See Matrix Specifications and TD_DFFT2 Output.

ART_SPEC
An ART that was produced by the TD_DFFT2 function. The ART_SPEC is required to contain the ART_SPEC parameter TABLE_NAME,. The parameter PAYLOAD with FIELDS and CONTENT is optional. Do not use any other ART_SPEC parameters.

See ART_SPEC Syntax Elements

FUNC_PARAMS
Name Data Type Description
HUMAN_READABLE INTEGER

[Dependencies: This is used when the input rows are in the raw, non-human-readable, format. The parameter is optional.]

Indicator that the DFFT2 coefficient rows are in human-readable or plottable form, or the output is in the raw form. Human- readable output is symmetric around 0, such as -3, -2, -1, 0, 1, 2, 3. Raw output is sequential, starting at zero, such as 0, 1, 2, 3.

A value of 1 means true and the output is in human readable form. A value of 0 means false and the output is in raw form. The default is 1.

ALGORITHM Enum, String

[Optional] The user-defined algorithm that bypasses the internal IDFFT2 planner, and influences the IDFFT2 algorithm associated with the primary IDFFT2 calculation.

Options are COOLEY_TUKEY, or SINGLETON. The default when this parameter is not present is that the internal IDFFT2 planner selects the most efficient algorithm for the operation.

INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT

A complex number that can be in rectangular (real, imaginary) or polar (amplitude, phase) form. The output options for univariate series are the following:

  • COMPLEX
  • AMPL_PHASE_DEGREES
  • AMPL_PHASE_RADIANS

The default is COMPLEX.

The OUTPUT_FMT CONTENT output for multivariate series are the following:
  • MULTIVAR_COMPLEX
  • MULTIVAR_AMPL_PHASE_DEGREES
  • MULTIVAR_AMPL_PHASE_RADIANS
  • MULTIVAR_AMPL_PHASE

The default is MULTIVAR_COMPLEX.