Overlap - 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 an Overlap analysis as follows:
    • Selected Overlap Columns
      • TWM_CUSTOMER.cust_id
      • TWM_CHECKING_ACCT.cust_id
      • TWM_CHECKING_TRAN.cust_id
      • TWM_CREDIT_ACCT.cust_id
      • TWM_CREDIT_TRAN.cust_id
      • TWM_SAVINGS_ACCT.cust_id
      • TWM_SAVINGS_TRAN.cust_id
  2. Run the analysis.
  3. When it completes, click the RESULTS tab.

    For this example, the Overlap analysis generated the following results. Note that the SQL is not shown for brevity.

    Overlap Analysis Example #1 Data (Part 1)
    xidx xtable TWM_CUSTOMER TWM_CHECKING_ACCT TWM_CHECKING_TRAN TWM_CREDIT_ACCT
    1 #records 747 520 46204 468
    2 #uniques 747 520 520 468
    3 TWM_CUSTOMER   520 520 468
    4 TWM_CHECKING_ACCT     520 384
    5 TWM_CHECKING_TRAN       384
    6 TWM_CREDIT_ACCT        
    7 TWM_CREDIT_TRAN        
    8 TWM_SAVINGS_ACCT        
    Overlap Analysis Example #1 Data (Part 2)
    xidx xtable TWM_CREDIT_TRAN TWM_SAVINGS_ACCT TWM_SAVINGS_TRAN
    1 #records 20167 421 11189
    2 #uniques 457 421 420
    3 TWM_CUSTOMER 457 421 420
    4 TWM_CHECKING_ACCT 373 315 315
    5 TWM_CHECKING_TRAN 373 315 315
    6 TWM_CREDIT_ACCT 457 297 297
    7 TWM_CREDIT_TRAN   287 287
    8 TWM_SAVINGS_ACCT     420