Tutorial #2 - PMML Scoring (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation
Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. Parameterize a PMML Scoring Analysis to score a Decision Tree model which predicts a discrete outcome as follows:
    • Select File Name — DecisionTreeDiscretePMML.xml
    • Selected Tables — twm_customer_analysis
    • Index Columns — cust_id

    • Model Output Options

      • P_ccacct1 — Enabled
      • P_ccacct0 —Enabled
  2. Run the analysis.
  3. Click on Results when it completes.

    For this example, the PMML Scoring analysis generated the following results. A single click on each page name populates Results with the item. SQL is always produced and displayed, but is not shown here for brevity.

    Tutorial #2 - PMML Scoring Report
    Resulting Scored Table Name Number of Rows in Scored File
    score_tree_1 747
    Tutorial #2 - PMML Scoring Data
    cust_id ccacct P_ccacct1 P_ccacct0
    1362527 0 0 1
    1363078 1 0.948387096774194 0.0516129032258065
    1362588 1 0.893333333333333 0.106666666666667
    1363486 0 0 1
    1362752 1 0.948387096774194 0.0516129032258065
    1362893 1 0.948387096774194 0.0516129032258065
    1363017 1 0.948387096774194 0.0516129032258065
    1363444 0 0 1
    1362548 1 0.948387096774194 0.0516129032258065
    1362487 1 0.948387096774194 0.0516129032258065
    ... ... ... ...
    ... ... ... ...
    ... ... ... ...