Two-source matching

Two-source matching involves a data source and a reference source.

The following types are available for two-source matching:

• Two-source many-to-one
• Two-source many-to-one, multiple
• Two-source many-to-one, duplicate
• Two-source one-to-one

For two-source matching, one or more columns on the data source must have equivalent columns on the reference source. For example, to match on family name and age, both sources require columns containing this information. The location, name, and length of a column in the data source can be different from its equivalent column in a reference source.