Tutorial - Factor Scoring - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
yuy1504291362546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

In this example, the same table is scored as was used to build the Factor analysis model.

  1. Parameterize a Factor Analysis Scoring Analysis as follows:
    • Selected Table — twm_customer_analysis
    • Evaluate and Score — Enabled
    • Factor Names
      • Factor1
      • Factor2
      • Factor3
      • Factor4
      • Factor5
      • Factor6
      • Factor7
    • Result Table Name — twm_score_factor_1
    • Index Columns — cust_id
  2. Run the analysis.
  3. Click Results when it completes.

    For this example, the Factor Analysis Scoring/Evaluation function generated the following pages. A single click on each page name populates Results with the item.

    Factor Analysis Score Report
    Resulting Scored Table <result_db >.score_factor_1
    Number of Rows in Scored Table 747
    Evaluation
    Variable Name Standard Error of Estimate
    income 0.4938
    age 0.5804
    years_with_bank 0.5965
    nbr_children 0.6180
    female 0.8199
    single 0.3013
    married 0.3894
    separated 0.4687
    ccacct 0.6052
    ckacct 0.5660
    svacct 0.5248
    avg_cc_bal 0.4751
    avg_ck_bal 0.6613
    avg_sv_bal 0.7166
    avg_cc_tran_amt 0.8929
    avg_cc_tran_cnt 0.5174
    avg_ck_tran_amt 0.3563
    avg_ck_tran_cnt 0.7187
    avg_sv_tran_amt 0.4326
    avg_sv_tran_cnt 0.6967
    cc_rev 0.3342
    Data
    cust_id factor1 factor2 factor3 factor4 factor5 factor6 factor7
    1362480 1.43 -0.28 1.15 -0.50 -0.31 -0.05 1.89
    1362481 -1.03 -1.37 0.57 -0.08 -0.60 -0.39 -0.55
    ... ... ... ... ... ... ... ...