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

Data Quality Data Cleansing Field Mapping Syntax


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

  • The user property name is labeled as: [connector name value] DataCleansing Field [n] where n is a sequential integer
  • The user property value consists of two or three strings enclosed in double quotation marks and separated by a comma and a space, such as:

    "Siebel Field", "Vendor Input Field"

    or

    "Siebel Field", "Vendor Input Field", "Vendor output field"

    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, for the connector identified as "namefirm", the two user properties preconfigured for the Account business component are shown in Table 19.

Table 19.  Data Cleansing Field Mappings
User Property Name
Value

namefirm DataCleansing Field 1

"Name", "drl_ifirmname1", "drl_firm_std1"

namefirm DataCleansing Field 2

"Location", "drl_ifirmloc1", "drl_firm_loc_std1"

TIP:   The data cleansing field mappings can use two or three values (the third value is optional). For some types of data, the connector can use the same field for input and output, while for other types of data the connector must use different fields for input and output. You need to consult with the third-party vendor to learn which field or fields to use. If you do not specify the Vendor output field, the Siebel application does not update the cleansed value to the field.

Siebel Data Quality Administration Guide