7.00.02 - When Reference Data Fits in Memory - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
English (United States)

Use this syntax when one input (a or b) fits in memory. The function compares each record from a and each record from b. The number of comparisons is |a|*|b|.

Version 1.1
SELECT * FROM IdentityMatch (
  ON source_input_table AS a PARTITION BY ANY
  ON reference_input_table AS b DIMENSION
  IDColumn ('a.id_column: b.id_column')
  { NominalMatchColumns ('a.columnX: b.columnY' [,...]) |
    FuzzyMatchColumns ('a.columnX: b.columnY, match_metric,
      match_weight [, synonym_file ]' [,...]) }
  [ Accumulate ('{a|b}.accumulate_column' [,...]')]
  [ Threshold ('threshold') ]