5.4.4 - Data Explorer - Teradata Warehouse Miner

Teradata Profiler Plug-in User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
tjx1484331808948.ditamap
dita:ditavalPath
ft:empty
Data Explorer performs basic statistical analysis on a set of selected tables or columns from selected tables in one or more databases. It stores results from four types of analysis based on simplified versions of the Descriptive Statistics analyses:
  • Values
  • Statistics
  • Frequency
  • Histogram

An answer table is produced for each type of analysis, the output including requested table and column names to allow results from multiple tables to be included in each answer table.

Each analysis can be selected individually, with the following exceptions:

  • If you select Frequency, you must select Values.
  • If you select Histogram, you must select Values and Statistics, including the Count, Minimum, Maximum, Mean, and Standard Deviation.

Data Explorer includes intelligence about which functions should be performed on which columns, with decisions based on column type and on results obtained. It also includes performance enhancements resulting in minimal passes on the input data. You can also specify a separate SQL Where clause to apply to each of the input tables selected for analysis.