TD_SEASONALNORMALIZE 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
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.