Time Series - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

The Time Series sub-category contains both new and traditional aggregation functions, but is only present when connected to a Teradata 16.20 or later database. Unlike many of the traditional aggregation functions, these aggregation functions may not be applied to columns of type date when applied to time series tables.

To invoke the time series version of these functions, remember to use the GROUP BY TIME SQL Element provided on the expert options tab, as described in the section Variable Creation - INPUT - Expert Options.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series