Matrix - Example #1 (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation
Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
This matrix will be used in the Linear Regression and Factor Analysis Tutorials in subsequent chapters.
  1. Parameterize a Matrix analysis as follows:
    • Selected Table and Columns
      • TWM_CUSTOMER_ANALYSIS.income
      • TWM_CUSTOMER_ANALYSIS.age
      • TWM_CUSTOMER_ANALYSIS.years_with_bank
      • TWM_CUSTOMER_ANALYSIS.nbr_children
      • TWM_CUSTOMER_ANALYSIS.marital_status
      • TWM_CUSTOMER_ANALYSIS.female
      • TWM_CUSTOMER_ANALYSIS.single
      • TWM_CUSTOMER_ANALYSIS.married
      • TWM_CUSTOMER_ANALYSIS.separated
      • TWM_CUSTOMER_ANALYSIS.ccacct
      • TWM_CUSTOMER_ANALYSIS.ckacct
      • TWM_CUSTOMER_ANALYSIS.svacct
      • TWM_CUSTOMER_ANALYSIS.avg_cc_bal
      • TWM_CUSTOMER_ANALYSIS.avg_ck_bal
      • TWM_CUSTOMER_ANALYSIS.avg_sv_bal
      • TWM_CUSTOMER_ANALYSIS.avg_cc_tran_amt
      • TWM_CUSTOMER_ANALYSIS.avg_cc_tran_cnt
      • TWM_CUSTOMER_ANALYSIS.avg_ck_tran_amt
      • TWM_CUSTOMER_ANALYSIS.avg_ck_tran_cnt
      • TWM_CUSTOMER_ANALYSIS.avg_sv_tran_amt
      • TWM_CUSTOMER_ANALYSIS.avg_sv_tran_cnt
      • TWM_CUSTOMER_ANALYSIS.cc_rev
    • Analysis Name — Customer_Analysis_Matrix

    There are no viewable results generated as a result of executing the Matrix analysis. The results will be viewed via the Export Matrix analysis tutorial. For more information, see Tutorial - Export Matrix Analysis (Teradata Database).

  2. Save the Matrix analysis with the above mentioned name "Customer_Analysis_Matrix” for use in the Linear Regression and Factor analysis tutorials.