TD_​GENSERIES4FORMULA

In building statistical ARMA-style forecasting models, a necessary precondition is that the time series being modeled be stationary: stationary with respect to mean; stationary with respect to covariance; and, stationary with respect to variance. Quite often, the time series that the data scientist wishes to model contains a trend - meaning that the time series is non-stationary with respect to the mean; or, alternatively may contain some periodicities (cyclic variance in data). This trend and/or periodicities must be removed before modeling may begin. Once the data scientist has devised a formula to represent the trend or periodic behaviors, their next task is to generate a series using that formula; such that they can then input both the original series and formula driven series through a pointwise subtractor function, which forms a new series with the trend and/or periodicities subtracted out.

Options

ESTIMATE_MODE
An indicator that the output table include the input parameters with the results. A value of 1 includes input parameters. A value of 0 only returns the results column. The default is 0.
FORMULA
A character string up to 64000 characters long which describes the formula to be applied. See the general FORMULA section for a complete description of supported math operators and proper formulation rules.
OutputFormat
Specifies the INDEX_STYLE of the output format.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The TD_GENSERIES4FORMULA function takes either: a self-generated series - GENSERIES_SPEC(); a pre-existing logical univariate series - SERIES_SPEC(CONTENT(REAL)); or, a logical multivariate series - SERIES_SPEC(CONTENT(MULTIVAR_REAL)); as input. It then produces a formula driven univariate output series, SERIES_SPEC(CONTENT(REAL)), in which the row-indexing mechanism is chosen by the user.

Output Ports

Icon
output of TD_GENSERIES4FORMULA

Nodes

Extensions

Links