Variable Creation - INPUT - Expert Options - SQL Elements - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

Nearly the same functionality is provided for creating expert options as for creating variables. The same SQL elements are supported with the following exceptions and additions:

  • Aggregations — Aggregations can only be used in the Having Clause.
  • Ordered Analytical Functions — Ordered Analytical functions can only be used in the Qualify Clause.
  • Other - Expert — A number of SQL Elements are available for expert options that are not available for creating variables or dimensions.