TD_UNNORMALIZE Function | Teradata Vantage - TD_UNNORMALIZE - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

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.