Siebel Data Quality Administration Guide > Universal Connector API > Data Matching and Data Cleansing Algorithms >

Batch Data Cleansing Algorithm


The algorithm is as follows:

  1. Load the vendor library.
  2. Call sdq_init_connector.
  3. Call sdq_set_global_parameter.
  4. Call sdq_init_session.
  5. Call sdq_set_parameter (RECORD_TYPE - Account/Business Address/Contact/List Mgmt Prospective Contact, BATCH_DATAFLOW_NAME).
  6. Query the Siebel CRM database to get the set of records to be cleansed.
  7. Call sdq_datacleanse. This function is called for each record in the result set of the query. It sends the driver record as XML and the output from the function has the cleansed driver record.
  8. After cleansing each record, save the record into the Siebel CRM repository.
  9. Call sdq_close_session while logging out of current session.
  10. Call sdq_close_connector.
Siebel Data Quality Administration Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.