Variable Creation - INPUT - Expert Options - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. On the Variable Creation dialog, click on INPUT.
  2. Click on expert options.
    The available Expert Options differ significantly depending on whether the user is connected to a Teradata or an Aster database.
    • (Teradata Database)
      Variable Creation > Input > Expert Options (Teradata)

      This screen provides nearly the same options as those provided by the Variable Creation - INPUT - Variables window, as described in Variable Creation - INPUT - Variables. The principal difference is that instead of Variables or Dimensions there are several expert clauses that may not be added to or deleted. Therefore, the New and Add buttons are not present. The Wizard button can be used only to add conditions, not Searched Case statements or Dimensions.

      The following Expert Options are available only on the Teradata database:
      • Qualify Clause
      • Group By Cube Clause
      • Group By Rollup Clause
      • Group By Grouping Set Clause
      • Grouping Set Clause
      • Sample Clause
      • Top Clause
      • Expand On Clause
    • (Aster Database)
      Variable Creation > Input > Expert Options (Aster)

      This screen provides nearly the same options as those provided by the Variable Creation - INPUT - Variables window, as described in Variable Creation - INPUT - Variables. The principal difference is that instead of Variables or Dimensions there are several expert clauses that may not be added to or deleted. Therefore, the New and Add buttons are not present. The Wizard button can be used only to add conditions, not Searched Case statements or Dimensions.

      The following Expert Option is available only on the Aster database:
      • Limit Clause