Data Explorer - Example #1

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K
  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.