After building a model as a means of deploying, it is required to allow scoring of new datasets. The way in which Teradata Warehouse Miner deploys a decision tree model is via SQL. A series of SQL statements is generated from the metadata model that describes the decision tree. The SQL uses CASE statements to classify the predicted value. Here is an example of a statement:
SELECT CASE WHEN(subset1 expression) THEN ‘Buy’ WHEN(subset2 expression) THEN ‘Do not Buy’ END FROM tablename;
Tree Scoring applies a decision tree model to a data set that has the same columns as those used in building the model (with the exception that the scoring input table need not include the predicted or dependent variable column unless model evaluation is requested).
A number of scoring options including model evaluation and profiling rulesets are provided on the analysis parameters panel of the Tree Scoring analysis.