Bookshelf v7.5: Data Quality Deduplication Field Mapping Syntax

Siebel Data Quality Administration Guide > Data Quality Configuration Options > Configuring Connector Mappings to External Vendors >

Data Quality Deduplication Field Mapping Syntax

Use the following syntax for each field in the deduplication field mapping user properties:

The user property name is labeled as: [connector name value] DeDuplication Field [N] where N is a sequential integer

The user property value consists of a pair of strings enclosed in double quotation marks and separated by a comma and a space, such as:

"external vendor field name", "Siebel business component field name"

TIP: Make sure there is a comma and a space between the two field values. Deduplication can fail if this syntax is not adhered to.

For example, if the Vendor1 connector is identified as "match", the user properties for the first three fields in the field mappings might be as shown in Table 15.

Table 15. Deduplication Field Mappings

User Property Name

Value

match DeDuplication Field 1

"MATCH_FIELD_FIRM", "Name"

match DeDuplication Field 2

"MATCH_FIELD_FIRMLOC", "Location"

match DeDuplication Field 3

"MATCH_FIELD_UNPADDRLINE", "Street Address"

Table 15. Deduplication Field Mappings
User Property Name	Value
match DeDuplication Field 1	"MATCH_FIELD_FIRM", "Name"
match DeDuplication Field 2	"MATCH_FIELD_FIRMLOC", "Location"
match DeDuplication Field 3	"MATCH_FIELD_UNPADDRLINE", "Street Address"

Siebel Data Quality Administration Guide
Published: 15 May 2003