Describe Verbose - Teradata Warehouse Miner

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

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

Calling this function returns several measures for a given column or expression, namely the minimum, maximum, mean and sample standard deviation, as well as the median, mode, 25th percentile, 50th percentile, and 75th percentile. (When using this function, the output option to store the tabular output in the database, that is create a table or view, cannot be used, nor can the analysis be referred to for input or referred to as a derived table by using the generate SQL only option.)

When dragging a Describe Verbose element into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series > Describe Verbose

A literal or column expression can be moved over the (empty) branch of the tree. The option to Use only the DISTINCT values in the expression is provided, resulting in the generation of DESCRIBE VERBOSE(DISTINCT ...). This option is enabled through the Properties panel. Double-click on Describe Verbose, or highlight it and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Aggregation > Time Series > Describe Verbose Properties