Hub
Pricing About
ComponentComponent

TD_GENSERIES4FORMULA

Teradata Team profile image
Draft Latest edits on 
Mar 28, 2024 5:15 PM
Drag & drop
Like
Use or download
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.

Component details

Input ports
  1. Type: DB Session
    Teradata Connection
    Connection to a Teradata Database Instance
  2. Type: Table
    Input
    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
  1. Type: Table
    output of TD_GENSERIES4FORMULA
    output of TD_GENSERIES4FORMULA

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME DatabaseTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Python IntegrationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits