Skip to Content
avatar image
Former Member

Matching fields

Dear Experts,

Ihave two field in which I have following values

Product Code Manufacturer

1000 Maxdata Ltd.

1000 Maxdata Ltd

1000 Maxdata

I have created the transformation which are are as belows

Field : Manufacturer

Token : To value has nothing

FROM TO

Ltd.

Ltd

In rules I have given below details

Fields Product Code & Manufacturer

Success : 100

In strategies I have mentioned

MaxScore : 100

High Threshold : 45

Low Threshold : 30

When I do the matchingusing selected vs selected. I get the score for 1st row 100 , for 2nd row 100 but I am getting

score 66 for 3rd row i.e. 1000 Maxdata.

I want to find out the reason how it calculated score as 66 and why not 100.

Thanks,

Kiran

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 07, 2011 at 01:08 PM

    Hi Kiran,

    if you use Token Equal, MDM compares each token in a string, i.e. if you match "1000 Maxdata Ltd." (3 tokens) against "1000 Maxdata" (2 tokens), you will get a 2/3 matching. 2/3 of 100 equals 66.

    Hope that helps.

    Best regards

    Christian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2011 at 01:13 PM

    Hi Kiran,

    This is because you have two tokens for 3rd record that is 1st token as 1000 and 2nd as MaxData.

    For complete understanding how it works, please refer given below both blogs: Equals Vs Token Equals

    /people/mandeep.singhsaini/blog/2010/08/24/matching-merging-equals-vs-token-equals-part-1

    /people/mandeep.singhsaini/blog/2010/08/24/matching-merging-equals-vs-token-equals-part-2

    Regards,

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2011 at 02:29 PM

    Thanks Mandeep & Christian

    Add comment
    10|10000 characters needed characters exceeded