Table 121. Data Quality Batch Job Parameters
Job Parameter or Server Manager Parameter |
|
|
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. |