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

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. Parameterize a PMML Scoring Analysis to score a Linear Regression model which predicts a continuous outcome as follows:
    • Select File Name — RegressionContinuousPMML.xml

    • Selected Tables — twm_customer_analysis

    • Index Columns — cust_id

    • Result Table Name — twm_pmml_score_reg_1

  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 #1 - PMML Scoring Report
    Resulting Scored Table Name Number of Rows in Scored File
    score_reg_1 747
    Tutorial #1 - PMML Scoring Data
    cust_id cc_rev
    1362527 -3.09123331353583
    1363078 17.1112717566361
    1362588 8.28237095448635
    1363486 27.7070270772696
    1362752 53.7221660256401
    1362893 -3.32443782325574
    1363017 14.7337070009494
    1363444 15.8410540579199
    1362548 35.790895539682
    1362487 11.3670140503415
    ... ...
    ... ...
    ... ...