FellegiSunterPredict Example 2: Supervised Learning Model - Teradata Vantage

Input

• Input table: fspredict_input, as in FellegiSunterPredict Example 1: Unsupervised Learning Model
• Model table: fg_supervised_model, output by FellegiSunter Example 2: Supervised Learning

SQL Call

SELECT * FROM FellegiSunterPredict (
  ON fspredict_input PARTITION BY ANY
  ON fg_supervised_model AS model DIMENSION
  USING
  Accumulate ('id', 'src_text2', 'tar_text', 'jaro1_sim',
              'ld1_sim','ngram1_sim', 'jw1_sim')
) AS dt ORDER BY id;

Output

The final column, match_result, contains the model prediction—M for match, U for no match. The weight column contains the weight of the object pair.