Additional Query Types - Teradata Warehouse Miner

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

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
ft:locale
en-US
ft:lastEdition
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

Additional unique types of queries can be created as outlined below:

  • Simple queries — Queries without input columns can be created. Some examples of what might be selected in such a query include literal constants, random values or system values such as current date or time.
  • Select Distinct — Use of the Select Distinct option results in only one of each duplicate row being returned. For example, the statement ‘SELECT DISTINCT product_code FROM table_A’ will return one each of every distinct value of product_code rather than the product_code for every row in the table.
  • Table only in expert clause — Support is provided for queries in which a given table is only referenced in an expert clause.