2.2 How It Works
This section explains how matching works.
- Evaluation Logic-> 46,4,26
- Evaluation score -> 0.88
- Word Match count (WMC_1) >= 2
- Abbreviated and CMP >=66
If the first name in Mapping Source Attribute column and Target Attribute column matched with a score of 0.88 and the Set threshold value is 0.75. The first name score is greater than the threshold value. Then 0.88x100x weightage (0.8) is provided in matching rule which gives you the score -> 70.4.
If Mapping Source Attribute column and Target Attribute column has the city data and the score value does not cross the provided threshold then it will not contribute to the score. Score is still 70.4
If city data cross the provided threshold, then it will contribute to the score as 100 (exact match). Then 100x0.05x weightage (0.05) => 5 is provided in matching rule which gives you the score 75.8.
If Mapping Source Attribute column and Target Attribute column has no city data, then score will cross the provided threshold. Then 50x0.05 => 2.5 is provided in matching rule which gives you the score 72.9.
Similarly, if other column data matches and score crosses the threshold, then the score will be added.