Managing Master Data with webMethods OneData 10.5 | Managing Master Data with webMethods OneData | webMethods OneData Consolidation MDM Guide | Working with Consolidation Projects | Working with Matching Projects for Consolidation (Staging) Objects | Defining Attribute Mappings for Data Quality Matching Projects
 
Defining Attribute Mappings for Data Quality Matching Projects
Use the following procedure to create a mapping from cleansing attributes to data quality servers. For a OneData matching project, the attributes are automatically populated, and you do not need to add more attributes. For other data quality matching projects, like Trillium and webMethods Integration Server, follow this procedure.
1. On the Menu toolbar, click Define > Data Quality > Consolidation > Project Mapping.
2. On the Command toolbar, click Add New Mapping.
3. In Project, select the appropriate (except OneData) data quality matching project.
4. In Attribute and Attribute Type, define the required inbound attributes to match and outbound attributes.
This is a sample listing of attributes that you could use. If required, you could also define attributes that meet your needs. Ensure that these attributes match the attributes processed by the matching server. For example, Trillium and webMethods Integration Server Matching.
Attribute
Attribute Type
Description
CLN_BusinessName
Inbound
CLN _StreetAddress
Inbound
CLN _State
Inbound
CLN _PostalCode
Inbound
CLN_BusinessName
Inbound
CLN _StreetAddress
Inbound
CLN _State
Inbound
CLN _Country
Inbound
WindowKey
Inbound
Hint
Outbound
A description on how the score and pattern were obtained. 400 characters is the preferred width of the staging column to which this attribute is mapped. To accommodate the possibility of a longer string, make suitable changes to the width of the staging column in the object definition so that the column holds the full string length.
Pattern
Outbound
Using the customer domain example, the possible values are:
*MASTER. Relevant only in a Multiple-Table Gold model. It indicates that only the customer attributes have matched. So there is a new address for the existing customer.
*BOTH. Relevant only in both Multiple-Table Gold and Single-Table models. In a Multiple-Table Gold model, it indicates that both the customer and address attributes have matched. In a Single-Table model, BOTH is the only value possible as all customer information is available in a single table.
18 characters is the preferred width of the staging column to which this attribute is mapped.
Score
Outbound
Values could be any number between 0 and 100. It indicates the similarity between the Consolidation and Gold records. 10 characters is the preferred width of the staging column to which this attribute is mapped.
Match Type
Outbound
Type of match executed:
*Good Match. When the score is greater than or equal to the good match threshold.
*Suspect Match. When the score is less than the good match range, but greater than or equal to the Suspect Match threshold.
*Below Suspect Match. When the score is less than the suspect match range.
*No Match. When no match candidates are available.
*Manual Match. On manual execution of the match hook.
50 characters is the preferred width of the staging column to which this attribute is mapped.
Matcher Action
Outbound
Includes the action set by the user in the Matching Configuration for each Match Type and details of how the action was executed. 200 characters is the preferred width of the staging column to which this attribute is mapped.
Possible values are:
*Create Gold - Created
*Process best match – Linked to existing gold record
*Process only if single match – Queued for manual match
*Process only if single match – Linked to existing gold record
*Queue for manual matching - Queued
*Do not process - No action
*Manually linked to existing gold record
Details
Outbound
Describes the reason for the matcher action. 200 characters is the preferred width of the staging column to which this attribute is mapped.
Possible values are:
*Gold record created
*Single match candidate found
*Multiple match candidates found
*All match candidates below Suspect Match
*No match candidate found
*Left for manual match
*Manual matching executed
*Queued for manual match
For example, let us assume you configured Action as Process only if single match for Good Match. Subsequently, the matcher executed the action Queued for manual match. The Details attribute explains that the reason for the matcher action. The reason might be, for example, Multiple match candidates found.
Project
Outbound
Name of the data quality project used to run the matching process. 400 characters is the preferred width of the staging column to which this attribute is mapped. To accommodate the possibility of a longer string, make suitable changes to the width of the staging column in the object definition so that the column holds the full string length.
Note: Gold objects and the associated attribute are disabled when you select the outbound attribute type.
5. If an inbound attribute requires Project-Object Mapping, select Is Required.
Note: If you select Is Required, you must define the Project-Object Mapping. In case there is no Project-Object Mapping for the attribute, validation errors occur during rule execution.
6. Click Save Mapping.
7. Repeat the procedure from step 2 onwards until you have added all the inbound and outbound attributes necessary for the project.
Copyright © 2011-2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.