Using Multiple Mapping

During a Batch Match, you can use Multiple Mapping to map more than one value to one or more fields. Doing this is useful when you are unsure which name or address to use, for example whether to use a business name or contact name, or whether to use a billing address or shipping address. By using Multiple Mapping, you can increase the possibility of finding a match, and you can improve the quality of the best match. Be aware that Multiple Mapping requires additional processing for each record and might impact the performance of the batch job.

The steps for running a Batch job using Multiple Mappings include:

• Mapping Additional Values to the input record, for example, mapping both a billing and a shipping address to the Address field.
• Setting Priority and Range for the mappings. In the case that both input values match and provide good candidates, Priority and Range determine which is the best candidate overall.

Mapping Additional Values

You can map up to four values to each of these customer record elements:

• Company Name
• Street Number
• Street Name
• City Name/Zip Code
• State/Province
• PO Box Number
• Telephone Number

Mapping multiple values for your batch job is helpful when you have input records with multiple addresses, such as billing and shipping addresses, and you're not sure if your input record will match a candidate on billing address or shipping address.

By using Multiple Mapping, you can include both addresses in the Address field to determine which is the better match. If both addresses match and provide good candidates, and both exceed the Confidence Code Threshold of the Workflow, Priority and Range will decide which the best candidate is.

You can also configure Multiple Mappings for more than one field. So, you could map multiple values for both Address and for Company Name.

Setting Priority and Range

You can change the Mapping priority to determine which of the possible matches is best. To do this, select Tie Breaking in the Matching Phase layer of the Batch Workflow. Then click on the Multiple Mapping tab to set the priority and range. The higher the names are in the list, the higher the Priority. The Range value indicates how close Confidence Codes must be to affect Priority. From the Mapping with the highest Confidence Code, you subtract the Range number to find the lowest Confidence Code to be considered in the Priority list. D&B Integration Manager does not use any Mappings outside this Range.

For example, if the highest Confidence Code for a given record is 9:

The following is an example of how the best candidate is chosen:

For seven sample records, where the best candidates for each of four mappings have the following Confidence Codes, this table shows which mapping is chosen as the best overall candidate for each record and why.

• The Confidence Code Threshold for the Workflow is 7.
• The Mappings Priority order is the Workflow is Orderer, ShipTo, BillTo, Approver
• The Range for the Workflow is 2.

The following table shows the Confidence Code of multiple mappings.

© Dun & Bradstreet, Inc. 2016. All rights reserved.

• © Dun & Bradstreet, Inc. 2019 – 2024. All rights reserved.