Minimum SQL Storage - 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

An additional feature of the Publish analysis is that only the variables necessary for the analytic model and the Score analysis are used. Because the focus of publishing is to store a model (Score SQL) for future use, it is wasteful to store SQL that generates variables that are not used. For instance, if a Variable Creation was executed that created 100 variables, but the model was created and then scored using only 5 of those variables, Publish will only store the SQL that is needed to generate those 5 variables in the Variable Creation analysis. In general, for a given ADS analysis, the only variables that are generated are the ones that are necessary for the subsequent analysis reference (see Bypassing Column Limiting and Other Features for more information).