Oracle Customer Hub (UCM) Master Data Management Reference > Configuring the MDM Foundation and Workflows > Cleansing Batch Data and Matching Data >

Parameters in Data Quality Batch Jobs


Table 122 shows the parameters used in data quality batch jobs. The names of the parameters for both Data Quality Manager component jobs and srvrmgr commands are given.

Table 122. Data Quality Batch Job Parameters
Job Parameter or Server Manager Parameter
Required
Description

Business component name (Bcname)

Yes

The name of the business component. The values include:

  • Account
  • Contact
  • List Mgmt Prospective Contact
  • Business Address. Applicable only to data cleansing operations.
  • For Siebel Industry Applications, the CUT Address designation is used instead of Business Address.

Business object name (bobjname)

Yes

The name of the business object. The values include:

  • Account
  • Contact
  • List Mgmt
  • Business Address. Applicable only to data cleansing operations.

Operation type (opType)

Yes

The type of operation. The values include:

  • Data Cleansing. Cleanses data.
  • Key Generate. Generates match keys.
  • Key Refresh. Updates match keys.
  • DeDuplication. Performs data matching.

Object Sorting Clause (objsortclause)

No

Applicable to data-matching operations only. Indicates how candidate records are sorted for optimal processing by the data-matching software. The default value is Dedup Token.

Object Where Clause (Objwhereclause)

No

Limits the number of records processed by a data quality task. Typically, you use the account's name or the contact's first name to split large, data quality batch tasks, using the first letter of the name. For example, the following object WHERE clause selects only French account records where the account name begins with A:

[Name] like 'A*' AND [Country] = 'France'

For example, the following object WHERE clause selects all records where Name begins with Paris or ends with London:

[Name] like 'Paris*' or [Name] like '*london'

Data Quality Setting

(DQSetting)

No

Specifies data quality settings for data cleansing and data matching jobs. This parameter has three values separated by commas:

  • First value. Applicable to Search Software America (SSA) only. Search Software America (SSA) is a data quality vendor which may be used. If this value is set to Delete, the existing duplicate records are deleted. Otherwise, the existing duplicate records are not deleted. This is the only usage for this value.
  • Second value. Applicable to the Universal Connector only. It specifies whether the job is a full or incremental data matching job.
  • Third value. Applicable to Firstlogic data quality software only. Firstlogic is a data quality vendor which may be used. It specifies the name of a dataflow file.

For more information about the use of the data quality setting, see Data Quality Guide for Oracle Customer Hub (UCM).

Key Type

No

Specifies a value for the key type data quality parameter. It is applicable to SSA only. For more information about this parameter, see Data Quality Guide for Oracle Customer Hub (UCM).

Search Type

No

Specifies a value for the search type data quality parameter. It is applicable to SSA only. For more information about this parameter, see Data Quality Guide for Oracle Customer Hub (UCM).

Threshold

No

Specifies a value for the Threshold data quality parameter. It is applicable to SSA only. For more information, see Data Quality Guide for Oracle Customer Hub (UCM).

Rule Name

No

Specifies the name of a data quality rule. A rule with the specified name must have been created in the Administration - Data Quality screen, for example:

RuleName="Rule_Batch_Account_Dedup"

For more information, see Data Quality Administration Guide.

Oracle Customer Hub (UCM) Master Data Management Reference Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.