Analysis Management - Teradata Warehouse Miner

Teradata Profiler Plug-in User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
November 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wzn1503087325188.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.