Data Manager Diff. Tab

[Former Member]

Hi Experts,

In data Manager Matching mode under rule tab there are fields Success and failure and undefined.

Under strategies tab High Threshold, low threshold, Min score and Max score

Under transformation tab preview .

Please tell me what are the functions of these fields?

Thanks

Shalini

[Former Member · Accepted solution]

Hi Shalini ,

The Transformations, Rules and Strategies tabs comprise the u201CDesign Timeu201D portion of Matching mode.

The Matches and Merge tabs on the other hand comprise the u201CRuntimeu201D portion of Matching mode.

Workflow Tab supports Matching and Merging Automation.

Terms and there Functions:

1. Normalization: When we remove the Special Characters as well as the Short forms from our data we say that the data is Normalized and this is used in Transformation technique.

2. Token: When we have to reduce the short forms they are known as Tokens.

3. Score : Score actually helps us to define the Result in the following ways:

u2022 Success : If we find the duplicate fields it shows Success

u2022 Failure : If we do not get any Duplicate field we say it is a Failure

u2022 Undefined : If any of the field contains Null Value we say that it is undefined.

There are two types of Scores also:

u2022 Maximum Score

u2022 Minimum Score

Maximum Score and Minimum Score: The read-only Min Score and Max Score properties are calculated automatically by MDM based on the Success scores of ever matching rule included in the strategy, and allow you to set the values of Low Threshold and High Threshold properties to classify the results.

4.Difference between Equals and Token Equals:

u2022 Equals : Exactly matches the data

u2022 Token Equals: Fuzzy Matches are also considered.

5.Threshold: There are two categories of Threshold:

u2022 High: Records whose total score is greater than or equal to the High threshold score are included in the list of potential matches in the Matches tab and placed in the High match level.

u2022 Low: Records whose total score is greater than or equal to the Low Threshold score are included in the list of potential matches in the Matches tab and placed in the Low match level.

The Tabs along with there Functionality:

 Transformation: It basically helps us to normalize the data.

 Rules: This tab is used to define certain rules for our search i.e. what rules needs to be followed to find out the Duplicate values.

 Strategies: Strategies are the collection of Rules, we try various combinations of the rules we have already created and then try to find out the Duplicate Records.

 Matches: In this tab we can see all the entries which are found to be duplicating in our data, here we need to include all those entries which we want to merge, so that we can get cleansed data.

 Merge: Merge on the other hand is use to merge the Duplicate data into one. It has further two parts:

u2022Set: This is used to select the data for a field of your choice among all the duplicate data that has been found.

u2022Concatenate: If we want to concatenate the two data for the same field then we use Concatenate.

Hope this would be helpful..

If helpful do reward points!!!!!!!!!!!

Regards,

Parul

[Former Member]

Hello Shalini,

Transformations are used to transform the abbreviations (Shot term) and to remove special characters.

For Ex: Bro> Brothers, Corp> Corporation or vise versa etc.

The Preview property shows the result of the transformation on the selected record.

Rules are used to define how fields are compared. Rules consist of a set of scores (success, failure and undefined) acting on a set of fields and a function.

Success defines the score if there is a match.

Failure defines the score if there is no match. Negative values can also be assigned.

Undefined defines the score if the content of a field is compared with a NULL value.

Strategies are used to determine which Rules are going to be applied and classify the results based on the value of threshold.

-->Records whose total score is greater than or equal to High Threshold are marked as High level match. Similarly records whose total score is greater than or equal to Low threshold are marked as Low level match.

-->Min Score and Max Score are calculated automatically. It is the sum of all individual matching rules in strategy

Hope this will clear your doubt and help you.

TNR,

Saurabh...

Reward if found useful.

[Former Member]

Hi Shalini,

In data Manager Matching mode under rule tab there are fields Success and failure and undefined.

Under strategies tab High Threshold, low threshold, Min score and Max score

Under transformation tab preview .

Please tell me what are the functions of these fields?

Success - This defines the score if there is match. That means if in two records , some field have similar value, the score will increase.

Failure- This defines the score if there is no Match. You can also assign Negative value in this. If a negative Value is assigned and the Valus for ttwo records is not equal, then that negative value is subtarcted from the taotal Score.

Undefined - This defines the score if the content of a field is compared with a NULL value.

This gives an additional score if any field in that particular record is a blank.

High Threshold & Low threshold will decide whether the Match result is a High or a low.

Max score is gnerally 100. it is total of the suceess and the Failure scores of the Rules you have selected in your stratergy.Max Score and Min score are Read Only properties.

Along with this, you can also refer this link:

[http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0677c82b40a2ee10000000a11466f/frameset.htm]

Go to->Matching Mode->matching Stratergy Definition-> Transformation properties and Matching Stratergy properties

Hope this helps.

Thanks and Regards

Nitin jain