Siebel Data Quality Administration Guide > Using the Value Match Method >
Value Match Method
Value Match is one of the methods of the DeDuplication business service. The Value Match method is used to match data in field/value pairs against the data within Siebel business components or to prevent duplicate data from getting into the Siebel application through non-UI data streams. Arguments
The Value Match method arguments consist of input and output property sets. Table 35 provides the input property sets, and Table 36 provides the output property sets. CAUTION: The Value Match property sets are specialized. Do not configure these components.
Table 35. Value Match Input Property Sets
|
|
|
|
Adapter Settings |
Code Page |
Code page. |
Optional. Override. Applicable only to SSA. NOTE: Properties specified as Override can be used to override the setting information obtained by the service from the administration screens, .cfg file, user properties, and so on.
|
Population |
Population values. |
SearchLevel |
The search level. |
Threshold |
The threshold score for a duplicate record. A match is considered only if the score exceeds this value. |
Generic Settings |
BC Name |
The name of the matched business component. |
Required. |
Update Modification Date |
If set to N, the match modification date is not updated. |
Not required. Default =Y. |
Use Result Table |
If set to N, matches are not added to the result table. Instead, matches are determined by the business service. |
Not required. Default = Y. |
Match Values1 |
<business component field names, value> pairs For example: (Last Name, 'ABC') (First Name, 'XYZ') and so on |
The matched business component's field name and the corresponding field value. For example: "Last Name", "Brown" |
These name, value pairs are used as the matched value rather than the current row ID of the matched business component. The user properties of the matched business component is used to translate the business component field names to vendor specific field names. |
Return Value
For each match, a separate child property set called Match Info is returned in the output with properties specific to the match (such as Matchee Row ID and Score), as well as some general output parameters as shown in Table 36. CAUTION: The Value Match property sets are specialized. Do not configure these components.
Table 36. Value Match Output Property Sets
|
|
|
|
Match Info |
Matchee Row Id |
The row ID of the matchee. |
|
Score |
The score of the match. |
Matchee row ID. |
Generic Settings |
End Time |
The run end time. |
Applicable only to SSA. |
Num Candidates |
The total number of potential matches if scores are not used. |
Num Results |
The number of actual matches. |
Row Value |
The row ID of the match or matches found. |
Start Time |
The run start time. |
Invoked From
Any means by which you can invoke business service methods, such as with Siebel eScript. Example
The following is an example of using Siebel eScript to invoke the Value Match method by way of a Siebel SmartScript. This script calls the Value Match method to look for duplicates of John Smith from the Contact business component and then returns matches, if any. After the script finishes, determine what you want to do with the duplicate records, that is, either merge or remove them. function Script_Open ()
{
TheApplication().TraceOff(); TheApplication().TraceOn("sdq.log", "Allocation", "All"); TheApplication().Trace("Start of Trace");
// Create the Input property set and a placeholder for the Output property set var svcs; var sInput, sOutput, sAdapter, sMatchValues; var buscomp;
svcs = TheApplication().GetService("DeDuplication"); sInput = TheApplication().NewPropertySet(); sOutput = TheApplication().NewPropertySet(); sAdapter = TheApplication().NewPropertySet(); sMatchValues = TheApplication().NewPropertySet();
// Set Generic Settings input property parameters sInput.SetProperty("Refresh Keys", "N"); sInput.SetProperty("BC Name", "Contact"); sInput.SetProperty("Use Result Table", "N"); sInput.SetType("Generic Settings");
// Set Match Values child input property parameters sMatchValues.SetProperty("Last Name", "Smith"); sMatchValues.SetProperty("First Name", "John"); sMatchValues.SetType("Match Values"); sInput.AddChild(sMatchValues);
// Set Adapter Settings child input property parameters sAdapter.SetProperty("Key Level", "Standard"); sAdapter.SetProperty("Population", "Default"); sAdapter.SetType("Adapter Settings"); sInput.AddChild(sAdapter);
// Invoke the "Value Match" business service TheApplication().Trace("Property set created, ready to call Match method"); svcs.InvokeMethod("Value Match", sInput, sOutput);
// Get the Output property set and its values TheApplication().Trace("Value Match method invoked"); var propName = ""; var propVal = ""; propName = sOutput.GetFirstProperty(); while (propName != "") {
propVal = sOutput.GetProperty(propName); TheApplication().Trace(propName); TheApplication().Trace(propVal); propName = sOutput.GetNextProperty()
}
TheApplication().Trace("End Of Trace"); TheApplication().TraceOff();
} See Also
For an example of how to invoke the Value Match method using Siebel Workflow, see Scenario for Data Matching Using the Value Match Method. For more information about Siebel Workflow, see Siebel Business Process Designer Administration Guide. For more information about business services and methods, see Siebel Developer's Reference.
|