FellegiSunter Example 2: Supervised Learning - Teradata Vantage

The unsupervised model is created like the supervised model, except the argument TagColumn ('match_tag') specifies the data for the on which to train the model. Supervised learning does not use initialization parameters.

Input

• InputTable: fstrainer_input, as in FellegiSunter Example 1: Unsupervised Learning

SQL Call

CREATE MULTISET TABLE "fg_supervised_model" AS (
  SELECT * FROM FellegiSunter (
    ON fstrainer_input AS InputTable
    USING
    ComparisonFields ('jaro1_sim: 0.8', 'ld1_sim:0.8', 'ngram1_sim:0.5',
                      'jw1_sim:0.8')
    TagColumn ('match_tag')
  ) AS dt
) WITH DATA;

Output

This query returns the following table:

SELECT * FROM fg_supervised_model ORDER BY 1;