Histogram - RESULTS - Data - Teradata Warehouse Miner - 5.4.4

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
  1. On the Histogram dialog box, click on RESULTS.
  2. Click on data (note that the RESULTS tab will be grayed-out/disabled until after the analysis is completed).
    Histogram > Results > Data

    Results data, if any, is displayed in a data grid as described in RESULTS Tab.

    The following is a description of the results returned by the analysis, depending on the options selected. If an output table is created, the columns in bold below will comprise the Unique Primary Index (UPI) of the output table.

    Without Cross-tab (Multidimensional Analysis)
    Name Type Definition
    xtbl VARCHAR (30) Table that the bin values are computed against, as specified in the “table” parameter.
    xcol VARCHAR (30) Column name or optional alias that the bin values were computed against, as specified by the “column” parameter.
    xbin INTEGER An integer representing the bin number.
    xbeg FLOAT Value that represents the beginning boundary for the bin of the column specified.
    xend FLOAT Value that represents the ending boundary for the bin of the column specified.
    xcnt FLOAT Number of records in the bin.
    xpct FLOAT Percentage of total records that this bin represents.
    ovly_COL Overlay Column Type Value of column to overlay within the bin. Only exists if Overlay Columns is specified. COL indicates the name or alias of the requested overlay column. This column will consist of unique categorical values that the bin is subdivided into.
    xocnt FLOAT Number of records within the bin in which this overlay column value is present. Created only if Overlay Columns is specified.
    xobpct FLOAT Percentage of records within the bin in which this overlay column value is present. Created only if Overlay Columns is specified.
    xopct FLOAT Percentage of total records in which this overlay column value is present. Created only if Overlay Columns is specified.
    xmin_COL FLOAT Minimum value of a requested “stats” column within the bin. Only exists if the Stats Columns option is specified. COL indicates the name or alias of the requested “stats” column. Multiple columns, if specified, will be created or displayed as a repeating group consisting of xmin_COL, xmax_COL, xmean_COL and xstd_COL for each COL name or alias (see xmax, xmean and xstd below).
    xmax_COL FLOAT Maximum value of a requested “stats” column within the bin. Only exists if the Stats Columns option is specified. COL indicates the name or alias of the requested “stats” column.
    xmean_COL FLOAT Mean (average) value of a requested “stats” column within the bin. Only exists if the Stats Columns option parameter is specified. COL indicates the name or alias of the requested overlay column.
    xstd_COL FLOAT Standard deviation of a requested “stats” column within the bin. Only exists if the Stats Columns option parameter is specified. COL indicates the name or alias of the requested overlay column.
    With Cross-tab (Multidimensional Analysis) Option
    Name Type Definition
    xbin_COL INTEGER Bin number of the column specified in the mandatory “column” parameter. COL is replaced with the name or alias of the requested column. Multiple columns, if specified, will be created or displayed as a repeating group consisting of xbin_COL, xbeg_COL, xend_COL for each COL name or alias.
    xbeg_COL FLOAT Value that represents the beginning boundary for the bin of the column specified. COL indicates the name or alias of the requested column.
    xend_COL FLOAT Value that represents the ending boundary for the bin of the column specified. COL indicates the name or alias of the requested column.
    xcnt FLOAT Number of records in the bin.
    xpct FLOAT Percentage of total records that this bin represents.
    ovly_COL Overlay Column Type Value of column to overlay within the bin. Only exists if the Overlay Columns option is specified. COL indicates the name or alias of the requested overlay column. This column will consist of unique categorical values that the bin is subdivided into.
    xocnt FLOAT Number of records within the bin in which this overlay column value is present. Created only if the Overlay Columns option is requested.
    xobpct FLOAT Percentage of records within the bin in which this overlay column value is present. Created only if the Overlay Columns is requested.
    xopct FLOAT Percentage of total records in which this overlay column value is present. Created only if the Overlay Columns is requested.
    xmin_COL FLOAT Minimum value of a requested “stats” column within the bin. Only exists if the Stats Columns option is specified. COL indicates the name or alias of the requested “stats” column. Multiple columns, if specified, will be created or displayed as a repeating group consisting of xmin_COL, xmax_COL, xmean_COL and xstd_COL for each COL name or alias (see xmax, xmean and xstd below).
    xmax_COL FLOAT Maximum value of a requested “stats” column within the bin. Only exists if the Stats Columns option is specified. COL indicates the name or alias of the requested “stats” column.
    xmean_COL FLOAT Mean (average) value of a requested “stats” column within the bin. Only exists if the Stats Columns option is specified. COL indicates the name or alias of the requested overlay column.
    xstd_COL FLOAT Standard deviation of a requested “stats” column within the bin. Only exists if the Stats Columns option is specified. COL indicates the name or alias of the requested overlay column.