Windowed Maximum - 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

Cumulative, Group, Moving and Remaining Maximum are supported within the Windowed Maximum function. This function derives a new column containing the maximum value of a column or expression. When one or more Partition Columns are specified, the maximum values are determined over the rows in each partition. Any of the Rows options may be used with this function. When dragging a Windowed Maximum function into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Logical > Windowed Maximum

Sort expressions can be built up in the Sort Expressions folder, and Partition Columns can be built up in that folder. The options to perform a Cumulative, Group, Moving or Remaining Maximum, and their associated options, are enabled through the Properties panel. Double-click on Windowed Maximum, or highlight it and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Logical > Windowed Maximum Properties

These options are defined below for each of the four types of Windowed Maximum.
  1. Aggregation Style — Cumulative
    Second Row Style
    • None, or
    • Current Row, or
    • Value Preceding, or
    • Value Following.

      (If Value Preceding/Following)

      Second Value — 0-n

  2. Aggregation Style — Group
  3. Aggregation Style — Moving
    • First Row Style
    • Current Row, or
    • Value Preceding, or
    • Value Following.

      (If Value Preceding/Following)

      First Value — 0-n

      Second Row Style

    • None, or
    • Current Row, or
    • Value Preceding, or
    • Value Following.

      (If Value Preceding/Following)

      Second Value — 0-n

  4. Aggregation Style — Remaining
    First Row Style
    • Current Row, or
    • Value Preceding, or
    • Value Following.

      (If Value Preceding/Following)

      First Value — 0-n