Cleansing Data Using Batch Jobs

The following procedure describes how to use a batch job to perform data cleansing on records in a selected business component. To effectively exclude selected records when running data cleansing tasks, you must add the following command to your object WHERE clause:

[Disable DataCleansing] <> 'Y'

Note: When you run a process in batch mode, any visibility limitation against your targeted data set is ignored. It is recommended that you allow a limited number of resources to access the Siebel Server Manager to run your data quality tasks, otherwise you run the risk of corrupting data.

Use the following task to perform data cleansing using batch jobs.

To perform data cleansing using batch jobs

1. Start the Server Manager program.

2. At the srvrmgr prompt, enter of the commands in the following table to perform data cleansing tasks.

Business Component	Example of Server Manager Command
Acccount	run task for comp DQMgr with bcname=Account, bobjname = Account, opType="Data Cleansing", objwhereclause="[field_name] LIKE 'search_string*'", DqSetting="'','','account_datacleanse.xml'"
Business Address	run task for comp DQMgr with bcname = "Business Address", bobjname="Business Address", opType="Data Cleansing", objwhereclause = "[field_name] LIKE 'search_string*'", DqSetting="'','', 'business_address_datacleanse.xml'"
Contact	run task for comp DQMgr with bcname=Contact, bobjname=Contact, opType="Data Cleansing", objwhereclause LIKE "[field_name]='search_string*'", DqSetting="'','','contact_datacleanse.xml'"
List Mgmt Prospective Contact	run task for comp DQMgr with bcname= "List Mgmt Prospective Contact", bobjname="List Mgmt", opType="Data Cleansing", objwhereclause LIKE "[field_name]='search_string*'", DqSetting="'','','prospect_datacleanse.xml'"