Values - Example #2 - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. Parameterize a Values analysis as follows:
    • Columns to Analyze
      • twm_customer.income
      • twm_customer.age
      • twm_customer.years_with_bank
      • twm_customer.nbr_children
      • twm_customer.marital_status
    • Compute the Number of Unique Values for each column — Enabled
    • Columns to Include in the Group By Clause — gender
  2. Run the analysis in the same manner described above. This time, the following Results were generated. The SQL is not shown for brevity:
    Values Example #2 Graph
    Gender xtbl xcol xtype xcnt xnull xunique xblank xzero xpos xneg
    M TWM_C… income INTEGER 329 0 284 0 45 284 0
    F TWM_C… income INTEGER 418 0 359 0 57 361 0
    M TWM_C… age SMALLINT 329 0 71 0 0 329 0
    F TWM_C… age SMALLINT 418 0 74 0 0 418 0
    M TWM_C… years_with_bank SMALLINT 329 0 10 0 37 292 0
    F TWM_C… years_with_bank SMALLINT 418 0 10 0 51 367 0
    M TWM_C… nbr_children SMALLINT 329 0 6 0 206 123 0
    F TWM_C… nbr_children SMALLINT 418 0 6 0 260 158 0
    M TWM_C… marital_status CHAR(1) 329 0 4 0 0 0 0
    F TWM_C… marital_status CHAR(1) 418 0 4 0 0 0 0
    Values Example #2 Graph

    As above, thumbnails are displayed, this time for each column and each group by column value, in Absolute Counts (bar graph) format. As the mouse passes over each thumbnail, the cursor changes to indicate a hyperlink, and the individual graphs can be maximized by clicking on the thumbnail. The Relative Counts (circle graph) are also available, each graph displaying both the column and group by column value. In the picture above, the data selection tab was first used to select all of the data, resulting in the display of page 1 of 2.