TD_UNNORMALIZE Function | Teradata Vantage - TD_UNNORMALIZE - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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.