TD_UNNORMALIZE Function | Teradata Vantage - TD_UNNORMALIZE - 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
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

TD_UNNORMALIZE reconstructs a series previously created by TD_SEASONALNORMALIZE. The TD_UNNORMALIZE function is usually used during the forecasting phase of modeling.

Seasonal normalization removes seasonal fluctuations from the data. This involves dividing each observation by the average value of the corresponding season. The transformation enables the detection of other patterns in the data, such as trends or irregular fluctuations, which may not be visible due to the seasonal variations.

After performing seasonal normalization, it may be necessary to un-normalize the data to obtain the original values. Unnormalizing involves reversing the normalization process to obtain the original values of the data.

The following procedure is an example of how to use TD_UNNORMALIZE when the series to be modeled is found to be nonstationary:
  1. Use TD_SEASONALNORMALIZE to make the series stationary.
  2. Develop the ARIMA forecast model.
  3. Use the ARIMA model to forecast the normalized series.
  4. Use TD_UNNORMALIZE on the forecasted normalized series to undo the effects of normalization and produce the final forecasted series result.