Values Results - 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

Values analysis results can be viewed in a grid, as thumbnails, and in graphs.

Grid View

The grid view of a Values analysis contains the following data, depending on the options you selected.

Name Type Description
COLUMN Group By Column Type Columns are created only if the group parameter is specified. Multiple columns, if specified, are created or displayed as the column name. These columns contain the unique values that the group by column takes on.
xdb VARCHAR (128) Database that the variable for the values operation resides in, as specified by the database parameter.
xtbl VARCHAR (128) Table that the variable for the values operation resides in, as specified by the table parameter.
xcol VARCHAR (128) Variable that the values operation runs against, as specified by the column parameter.
xtype VARCHAR (50) The data type of this variable.
xcnt FLOAT The total number of occurrences of this variable.
xnull FLOAT Total number of rows where this variable takes a null value.
xunique FLOAT Total number of rows where this variable takes a unique value.
xblank FLOAT Total number of rows where this variable is blank.
xzero FLOAT Total number of rows where this variable is equal to 0.
xpos FLOAT Total number of rows where this variable has a positive value.
xneg FLOAT Total number of rows where this variable has a negative value.

Thumbnail View

The Values Thumbnail view displays results as thumbnails grouped by database and table of all the possible graph generations per column.

Graph View

The Values Analysis graph view displays a bar graph of the zero, null, unique, positive, and negative results for the selected columns