TD_SEASONALNORMALIZE Syntax Elements - 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
SERIES_SPEC
Single input source that contains univariate series instances. The associated payload-content is REAL. The payload is the series element magnitude. SERIES_SPEC must include the usage of the INTERVAL parameter that is the interval to used by the function to divide the series cycles into intervals, such as the following:
SERIES_SPEC (TABLE_NAME(StoreSales), SERIES_ID(StoreNum), ROW_AXIS(TIMECODE(StoreDays)), PAYLOAD FIELDS(Sales), CONTENT(REAL), INTERVAL(CAL_MONTHS(1)))

See Series Specifications.

FUNC_PARAMS
Name Data Type Description
SEASON_CYCLE Enumerated type The parameter that groups the CYCLES and DURATION parameters in order to describe the overall cycle occurring each season. For example, a yearlong seasonal cycle could be described as follows:
SEASONAL_CYCLE(CYCLES(“CAL_YEARS”), DURATION(1))
CYCLES Enum, String The time-unit associated with a seasonal cycle with one of the following values:
  • CAL_MONTHS
  • CAL_DAYS
  • WEEKS
  • DAYS
  • HOURS
  • MINUTES
  • SECONDS
  • MILLISECONDS
  • MICROSECONDS
DURATION Integer The number of the time-units described in CYCLES which make one seasonal cycle.
SEASON_INFO Integer [Optional] An indicator to generate some additional result columns CYCLE_NO and SEASON_NO. CYCLE_NO is the n-th cycle of the season. SEASON_NO is the season for the data. Values starts from 1. The indicator value is between 0 and 3, as follows:
  • 0 indicates no extra columns being generated.
  • 1 indicates SEASON_NO column being generated.
  • 2 indicates CYCLE_NO column being generated.
  • 3 indicates both SEASON_NO and CYCLE_NO columns being generated.

The default is 0.

INPUT_FMT
No INPUT_FMT options are available for this function.
OUTPUT_FMT
[Optional] The INDEX_STYLE of the output format. Options are NUMERICAL_SEQUENCE or FLOW_THROUGH. The default is NUMERICAL_SEQUENCE.