Avoiding Teradata Warehouse Miner Keywords

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
User Guide

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.