Siebel Data Quality Administration Guide > Configuring Data Quality >

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

1. 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:
   1. In the BC Vendor Field Mapping, configure the business component operation shown in the following table:

      Business Component Field	Operation
      CUT Address	DeDuplication

   2. In the Vendor Parameter, configure the value shown in the following table:

      Name	Value
      CUT Address DeDup Record Type	CUT Address

   3. In the field mapping for CUT Address, enter the values shown in the following table:

      Business Component Field	Mapped Field
      PositionCity	PAccountCity
      Country	PAccountCountry
      Postal Code	PAccountPostalCode
      Row Id	PAccountAddressID
      State	PAccountState
      Street Address	AccountStrAddress

2. In your Siebel application, navigate to the Administration - Data Quality screen, then the Data Quality Settings view, and:
   1. In the Value field for the parameters shown in the following table, specify the appropriate settings.
   2. Log out of the application and log back in for the changes to take effect (you do not have to restart the Siebel Server).

      Parameter	Description
      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.