When Reference Data Does Not Fit in Memory - Aster Analytics

SELECT * FROM IdentityMatch (
  ON  source_input_table  AS a PARTITION BY  key 
  ON  reference_input_table  AS b PARTITION BY  key 
  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') ]
);