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.1SELECT * 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') ] );