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
2023-12-08
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.

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.