Data Quality Guide for Oracle Customer Hub > Configuring Data Quality with Oracle Data Quality Servers >
Configuring Deduplication Against Multiple Addresses
When using the Oracle Data Quality Matching Server for data matching, you can configure deduplication against either the primary address or all address entities. When Oracle Data Quality is configured to carry out deduplication against all address entities, this helps identify duplicates between records that have similar non primary addresses. Previous to this release, deduplication was carried out on the primary address only.
- For account, you must use the Account Match Against parameter to specify whether to match using one of the following:
- All Address
- Primary Address
- For contact, you must use the Contact Match Against parameter to specify whether to match using one of the following:
- All Address
- Primary Address
NOTE: You cannot perform deduplication against both All Address and Primary Address. Only one option can be used for deduplication. Choosing to carry out deduplication against all addresses is performance intensive.
The following procedure describes how to configure deduplication against multiple addresses. Once configured, deduplication against multiple addresses applies in real-time, Universal Customer Master (UCM) or Enterprise Application Integration (EAI) insertion, and batch match processing modes. To configure deduplication against multiple addresses
- In your Siebel application, navigate to the Administration - Data Quality screen, then the Third Party Administration view, select the ISS Vendor Name (DLL Name: ssadqsea) and:
- In the BC Vendor Field Mapping, configure the business component operation shown in the following table:
|
|
CUT Address |
DeDuplication |
- In the Vendor Parameter, configure the value shown in the following table:
|
|
CUT Address DeDup Record Type |
CUT Address |
- In the field mapping for CUT Address, enter the values shown in the following table:
|
|
PositionCity |
PAccountCity |
Country |
PAccountCountry |
Postal Code |
PAccountPostalCode |
Row Id |
PAccountAddressID |
State |
PAccountState |
Street Address |
AccountStrAddress |
- In your Siebel application, navigate to the Administration - Data Quality screen, then the Data Quality Settings view, and:
- In the Value field for the parameters shown in the following table, specify the appropriate settings.
- Log out of the application and log back in for the changes to take effect (you do not have to restart the Siebel Server).
|
|
Account Match Against |
Set to one of the following:
- All Address to consider all addresses associated with an account for deduplication.
- Primary Address (the default value). If set to Primary Address, then only the primary address associated with an account is considered for deduplication.
|
Contact Match Against |
Set to one of the following:
- All Address to consider all addresses associated with a contact for deduplication.
- Primary Address (default value). If set to Primary Address, then only the primary address associated with a contact is considered for deduplication.
|
Enable DQ Multiple Addresses |
Set the value of this property Yes. |
Enable DQ Sync |
Set the value of this property to Yes. |
|