7.00.02 - When Reference Data Fits in Memory - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
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') ]
);