Avoiding Teradata Warehouse Miner Keywords - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

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

Much like Teradata keywords, Teradata Warehouse Miner has “special’ reserved words which may conflict with an analysis. This is particularly true for the Descriptive Statistics analyses. In many cases, such conflicts, though rare to occur, can be avoided by using an alias. In some cases, it may be necessary to define an SQL View on the table to be processed in order to rename the conflicting columns. The Teradata Warehouse Miner keywords are defined in the Results—data or equivalent section for each analysis with pre-defined output column names.

In addition to avoiding those keywords defined in the Results—data section, analyzing columns which begin with “_twm” should be avoided, as this is the convention used when a Teradata Warehouse Miner analysis has to generate a temporary column name.