1. Data Quality for Oracle Customer Hub Guide
  2. sdq_datacleanse Function

sdq_datacleanse Function

This function is called to perform real-time data cleansing. The function is called for only one record at a time.

Item Description
Syntax 
int sdq_datacleanse (int session_id, SSchar* parameterList, SSchar* 
inputRecordSet, SSchar* outputRecordSet)
Parameters

parameterList: An XML character string that contains the list of parameters and values that are specific to this function call. An example of the XML is as follows:

<Data>
    <Parameter>
        <Name>RealTimeDataCleanseParam1</Name>
        <Value>RealTimeDataCleanseValue1</Value>
    </Parameter>

    <Parameter>
        <Name>RealTimeDataCleanseParam2</Name>
        <Value>RealTimeDataCleanseValue2</Value>
    </Parameter>
</Data>
Note: This parameter is set to NULL as all required parameters are already set at the session level.

inputRecordSet: An XML character string containing the driver record. An example of the XML is as follows:

<Data>
    <DriverRecord>
        <Contact.FirstName>michael</Contact.FirstName>
        <Contact.LastName>mouse</Contact.LastName>
    </DriverRecord>
</Data>

outputRecordSet: A record set that is populated by the vendor in real time and which contains the cleansed record. An example of the XML is as follows:

<Data>
    <CleansedDriverRecord>
        <Contact.FirstName>Michael</Contact.FirstName>
        <Contact.LastName>Mouse</Contact.LastName>
    </CleansedDriverRecord>
</Data>
Return Value

A return value of 0 indicates successful execution. Any other value is a vendor error code. The error message details from the vendor are obtained by calling the sdq_get_error_message function.