Data Explorer - Example #1 - 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 Data Explorer analysis as follows:
    • Input Source — MultiTable
    • Available Databases — The database where the demonstration data was installed.
    • Available Tables
      • TWM_CHECKING_ACCT
      • TWM_CREDIT_ACCT
      • TWM_CUSTOMER
      • TWM_SAVINGS_ACCT
    • Analyses to Perform
      • Values — Enabled
      • Compute Unique Values … — Enabled
      • Statistics — Enabled
      • Frequency — Enabled
      • Histogram — Enabled
    • Output
      • Values Analysis Output Table — twm_values
      • Statistics Analysis Output Table — twm_stats
      • Frequency Analysis Output Table — twm_freq
      • Histogram Analysis Output Table — twm_hist
  2. Run the analysis.
  3. When it completes, click in the RESULTS tab.
    • Data — The data generated by the Data Explorer analysis is too extensive to show here, but four output tables are generated.
      • twm_values (42 rows)
      • twm_stats (26 rows)
      • twm_freq (198 rows)
      • twm_hist (193 rows)
    • Graph — The following is a snapshot of the graph object created for this example.
      Example Data Explorer Graph

    • SQL — The generated SQL is omitted for brevity.