Analysis Management - Teradata Warehouse Miner

Teradata® Profile Plug-in User Guide

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

The descriptive statistical analyses in Teradata Profiler provide a variety of functions to analyze and explore a Teradata database. Analyses must be contained in a project in Profiler. You can add an analysis directly in a project, at the connection level, or at the folder level. If you add the analysis at the connection or folder level, you must first select or add a project within the Analysis wizard.

In the case of the Descriptive Statistics, NULL values are handled through the generated SQL aggregate functions. In this case, SQL ignores the NULL value and adjusts the number of observations in its calculation. This effectively provides a listwise deletion of NULL values.