Additional Query Types - 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

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.