When Reference Data Fits in Memory - Aster Analytics

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') ]
);