Match types for the Two-source Match stage
The Two-source Match stage match type determines the relationship among the match passes, the records that are processed by each of the passes, and how the groups are formed.
When you use the Two-source Match stage, you select one of the
following match types.
- Many-to-one
- Any reference source record can match many data source records.
Any one data source record can match only one reference source record.
For example, if
101 Main St.
on the data source matches two records on the reference source:101-199 Main St SW
and101-199 Main St SE
, the first reference source record is the matched record and the second reference source record is not considered a match to this particular data source record. It is possible that the second reference source record will match another data source record. - Many-to-one multiple
- Each reference source record having the same weight as the matched
pair when it is scored against the data record is flagged as a duplicate
record. Any one data source record might match more than one reference
source record. For example, if
101 Main St.
on the data source matches to two records on the reference source:101-199 Main St SW
and101-199 Main St SE,
one reference source record is the matched record and the other is the duplicate. - Many-to-one duplicate
- Like the many-to-one multiple option, except that additional reference source records that match
to a level beyond the duplicate cutoff value are flagged as duplicates. This functionality means
that records with lesser weights than the match weight can be flagged as duplicates. For example, if
101 Main St
on the data source matches to three records on the reference source:101-199 Main St SW
,101-199 Main St SE
, and101 Main Rd
, you get101-199 Main St SW
as the match, and both of the other addresses might be duplicates. - One-to-one
- Matches a record on the data source to only one record on the reference source. A record on the reference source can match only to one data source record.