Siebel Data Quality Administration Guide > Using Siebel Data Quality >

Data Quality Batch Job Parameters


Table 13 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 13. Data Quality Batch Job Parameters

Job Parameter/Server Manager Parameter

Required
Description

Buscomp name

bcname

Yes

The name of the business component: Possible values include:

  • Account
  • Contact
  • List Mgmt Prospective Contact
  • Business Address - applicable to Data Cleansing operations only

Business Object Name

bobjname

Yes

The name of the business object. Possible values include:

  • Account
  • Contact
  • List Mgmt
  • Business Address - applicable to Data Cleansing operations only

Operation Type

opType

Yes

The type of operation: Possible values are:

  • Data Cleansing - cleanses data
  • Key Generate - generates match keys
  • Key Refresh - refreshes 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 up 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'

As another 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 SSA only. If this value is set to Delete, existing duplicates are deleted. Otherwise, existing duplicates 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 only. It specifies the name of a dataflow file.

For more information about the use of DQSetting, see Matching Data Using Batch Jobs.

Key Type

No

Specifies a value for the Key Type data quality parameter. This is applicable to SSA only. For more information about this parameter, see Table 11.

Search Type

No

Specifies a value for the Search Type data quality parameter. This is applicable to SSA only. For more information about this parameter, see Table 11.

Threshold

No

Specifies a value for the Threshold data quality parameter. This is applicable to SSA only. For more information about this parameter, see Table 11.

Siebel Data Quality Administration Guide Copyright © 2006, Oracle. All rights reserved.