Fuzzy matching compares source and target, =
and gives a similarity score
Score
measures how “close” two strings are
Score=
=3D
1 : Perfect match
Score
=3D 0 : No match
̶=
0;InaPlex”
and “inaplx” : 98%
̶=
0;InaPlex”
and “innerplex” =
: 87%
“InaPlex”
and “ibm” =
;
: 49%
See T=
ools
– Fuzzy Match Demo
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0033_image005.gif
Content-Transfer-Encoding: base64
Content-Type: image/gif
R0lGODlhCwENAXcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G
RklDRTkuMBMAAAAHdElNRQfYAxUJOCLf8C8PACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA
If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh
aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF
OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAIEUxdiAAsAAAAAAsBDQGDAAAAMWrFcW9kgICArKiZ7OnY
8e/i////AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDA/9Yuqz2MMpJq7046827/2Aojk9jnmiqrmzr
vnAsz3Rt33iu73zv/8CgcEgsGo/IpHLJbDqf0Kh0Sq1ar9isdsvter/gsHhMLpvP6LR6zW673/C4
fE6v2+/4vB5H6Pv/gIGCg4SFhoeIiYqLjIUuJJAhNwQClZaXmJmam5ydnp+goaKjpJyPkagckwIH
ra6vsLGys7S1tre4ubq7vLOnDwDBqRPBwiOrvcnKy8zNzrm/ABDSw9PWFdQXyM/c3d7fz9HVFNkG
5RHnFNsAucXBrezg8vP0tOLExtnS+cbm/cDopvED9q+EDUrw2r1iF6+ew4fffvnTZ40iNYvXAGas
SEz/wjqFrhhCHEmSmcRrGAFelOCunEuBwvQV83iQ1YF4DBsWSxjyJrx3PoOWHEr0pMaU5pIq3RgQ
Jcel5z7exAkr506fOoM2JMoV4j2lKWNqTEoxY1myY6PW5Jl16rutCVv+7ErXawt0/2YSREtQ5jl3
LPVe1AtBatbDsURWhVu3sTej4yIb7om4qlDFjB1rNnk3sufCa7X2dKt44U+qQjerXgb5c6ptq2PL
bu06EmzZuDXTrk3idu7fXXfzFuEbuHGSe1oQGM68ufMKyVkcn140uvXr2LNr3869u/fv4MOLH0++
vPnz6NOrX8++vfv38OPLn0+/vv37+PPr389fSsv//wAGKOCABBZo4IEIJqjgggw26OCDBbIAQCMU
VmjhhRhmqOGGHC4ywIcghgiihASQVCJ1KKZICwEitvghiQcYUWJ/YbDooogwyhhjdjPyeCOOK0y4
IxE9YlfkdTb++GKQRwrRZAEtzeAOGE9CGQweSSqZYxFVQvkCAA2AqYCYJ5ApxZNkmjlHlj9uSeSQ
YX4Z5wJq0lkFmnuweaObQ3SpZjF0inmlnYRaKeihdSaBpwmAjjnoo4NSqeSITMLppKWFejmmpmD+
yUCdnTLqRJWNauplmpxm2oWeLvJ5KQpmRmmqp4VOmWapS3S5qam7nuoorqtOuqQKQuoI66dl9qqs
oP92MqusErqmiuymzo7BaouuBuHntL52W+u31SZ6xKLSehvqrDUKO0C2QGz7aaTwvhvpr85O2QSp
85ba6K3ianEtkMRGy4PAdxBsx78hsvuDwXUwTAfClAaMabsT05gFxMOmMGGHHHfs8ccgh4yhujCO
dKKK85yMMjgYr1upjivLo3LM3bSssA8z0/xMzjo3Y/PLXPbsDc9CK/OzxDAX7QzRSvNytMYOT9L0
0lP7TDLQb452i1ypxZxzZlXP8jSsUR9kGi5blUazyleFfcvYZZZdA9sgxSX0127jAjejctNAN1Y6
AZW2VoLzZBzeeduyd5h9z/B34aZxXRpm0yGe+Ir/VyMd9GhtudM14FcBdZzll8uy+KeNy/A4Zaxb
xpjohydWOubC3tzD6nbnHnnrYMdG+uyvnE5n6jHgTvhbsrvFVuXJAw+L8GMSDwPTzgdf/duZQ10x
ztcr3n0t0EMp/QvUd1/+9eEXu/n3prMvdvZkb3+7++3T/zz8ccs/sP3P8x88/nyLkcgIUIABGvCA
CEygIQDIuBg9pID+c8X5qpe+8blggs7DIPAqqL8daHB2HywdB5PmvxBeboTrK2EEW4HCrEXQhIlr
YZ/Oxoveqeh3FGQg6jqoAxhapmhsgx36dDg8HubAhzTsGQ4zSMToGZEPuxNd6EJ3muVRZ4kbbKL4
/54oNcqgpnVYuYxortg882lRfS4MI1t2ghjJ2VA2WAThGS2onN3pbnJqXMgbfVfGIdYOazMEIx7b
yDsUxVGEc+Si2QR5Gqughoqf+80hT5hIEtatakgMmwwvVcO8ZRKTlUwh/z45tU1qa4UHIGXTTEmx
FapSaaxcGCpfCcRKDrCACsylLnfZsUo+kJZ3m2Uo0zhKYf5Rc8S0HzCVOMxAvtCYk7Ld/lwJTS0B
kpPPdGUzsRlJtOkCbHt8yMzaFhIhhtOQ2zyl1jqpkNc55m+pactUSpnOVhqOnd50Z2PgOTjDCZGZ
x9QeCakiRcFB8qCRwwk5u8JPGhKUngGN30Dn0v+1QYrxi2qUJ10aqsfCnfOK9ZQl5zjHRta50XX+
fKdDZ0G5VYaUeyO940U/Z84xdrMkHJUd12oZ0fxNdKYytWg8bfpReuRUjOu820vnF9PjOXKNjzyb
Qv9JlHFCTnlJVGpPA2jJS66ymm26pjrxWUqw7kms9lShNrfawK7Sb5k6iyVMs/nCpU6TriW0pchw
ycu++vWviPClQyBIzbVGE60ixeso7erBWZq1VYidq1rrytYdutV9cF0bY3voWMNaE5nOvGktigoc
q76uoKQ93GaP6IzU5uaolRHtDVcLxWa4FjewZSQsadtFu6G2kbm7rWZyK9PdVraIE71qUG2KsqP/
kqaKLj2uE5NLUuQFV7jDXaks8Gjcw4KWm0LNI2awq1KtgROpPPWuQFMYXoti9IbaTalGAapeibIX
qZ7zXEbXtpgvtm2h9P3sepO5NU8+FluRZeouyCvJAwNswKEtpmfD+t2xTjav0t3iZdmXWa/xdpGK
VaZeQ8ZXwJr4xH8VbD0IG+K3fnhunaVsfX0qSmU6OGEJvuuFF5thNEbYxhM+a4XTKmEZC9i+aWRw
VkfX38QYFMCa7TEdWdBh2cIxvui9Z4ApDGFufkPJOMWyRsG8GbkqOIweDZxCn3s8K66GuEON7oy5
et80L3emlSFzzbCMVS1rdc5trTMj5eJf0BkU/7diNi8opaxIGA8ajG4WyWkRrehK67nML/abHcUL
VEIG98qVTqmVm5tpx22auwdNdVT52FF/SlGTpVZdNy5d1RtHrMsWtq0SbZ0xJP/4rbx22ZATu2MR
M3rD36syqY9dY2AHGbJIuyWKp03tXKqYHiwutouZTWDMBluajS2skbnsay8DedxCxjWRz41hQFu2
2d5+NoKHLVkl09pkTc73Tv98ZBp3e8m2uDdE4AwXgXPFzDpmKVlTRHCAR9ndyBX0obH6FlW7GdSi
zvio0cnt0Obk0yBHcyFfy2dyGpyhsS7eqZ3aUjTrl6qqabift5zucltYqAWXL01PTrVQ4xfWHf8H
b6dHLvKQYzzLnQM6xKcraCuq+pGQ4zkzTOvq+aa333T+9zdh+e0ch5sZUse3vB9s83U7G93QVjex
i9xurAda6+brOr3PzHYeL13D0q623vf+sWvPI9t1N/bdfWzus7ed3P7+dbzRPm+1Szbw2x78lFeg
bPiOHcdzTzi77e72d8N94ZYv52nVDFHJN1rTs45root7dcRnXfHKCLtRV19ROXc+4kmeJ+BED9w2
M5fSGp+v7Aee8unpMS7vdS/RSe5zNuu+u7dneu6Lm1+Tvnz4y3BuUrHvEIR/Haic9vTxY9f87dve
9W/3+KOXm2fyB1+3ra954oVOfTZa/PdHpzj/76ELffR7Hvbe9FWXd2tlt3agp3oD2Gvzl2ubJ3jR
p2HwxmFy53h014CR94CEx4CGx3n+h1x5x3cgGIIX4nfyUEABcIIomIIquIIs2IIu+IIwGIMy2IKV
x3DFRz4zmIM6uIM82IM1yHGmJyM9OIREWIQ7+IMgFXTaYoRM2IROGABIWDk3eEFPWIVWmINRODpT
qBxX2IVeuIJZqFod1y98kIIHEABn+IVqyIRUt13713/y93rzMjArmIZreIc+yGe6Z3UPh4FHAiw9
VId4OIhHqIdXxX31IEP2QocoeIavcIKugIZ2SIiE6Fwth4hG1Uyy4kFmiIaN6ImgOImUeIeW/3gZ
UOZhYwiIZfiJduiIkPiKoziIxKVP8Zd2vqaKq/iKrRiKsBiLpChm+pVUcaWJZHgQnbiLaZiMvoiH
2kdU5xeH6VeMxsiKkciLoLiMatiGOcd/tdh4BYgz2BiONDiB33g74niOKRiGpbWFVIaO7qiOksSO
lOeO6AiPryWPKkAA9HiO9ohb+JgC+riP4diPcDRiIFNiIpiQCrlAx/ZLMXZ40Ph/hbd4EGmLC2h2
FMmBEYl7ABh3CShsFKh5G+iAHSh9HYk+5HiRvMJa4laR3jh/9cJZLamRFvl61LKSIKZtmFVPuIh6
LbaTqQggLPmTHMaTc9hbOlmUShgq0kg+Dz1Jky9pkzE5lEmZbCHVlMY3kyS5kSY5kRL4keAmk0Rp
lUqIkV/JeGSnko9ngUAZhBGYbClpkxqYkVvpIgkAADs=
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0034.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
How it Works
As with Standard matching, Fuzzy <=
/span>match
&=
#8226; Can use any field or combination of fields
&=
#8226; Reads the match fields
&=
#8226; Builds an in memory index for each table
• The target match expression is applied to the field data read from the table
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0050.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
How it Works
Set scoring levels=
• Score > Upper
• good
match – accept immediately
• Lower < Score < Upper
• Pos=
sible
match – user review
• Score < lower
• Not=
a
match – reject
•<=
/span>
No
match < Lower < Possible < Upper < Good
No
match < 85% < Possible < 95% < Good
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0035.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
How it Works
When a source record comes in:
&#=
8226; Source expression applied to build match value
• Source match value scored ag=
ainst every value in target index
&=
#8226; “Best” matches used – you set boundaries=
3;
&=
#8226; No match < Possible match < Good match
&=
#8226; No
0.85
Possible
0.95 Good=
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0016.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
How it Works
User
Review
• Sho=
ws the
source record and possible matches in target
• Use=
r can
select one or more records as match
• Opt=
ions
•<=
/span> Review “good” and
“possible” matches
–<=
/span> For testing purposes
•<=
/span> Review just “possible”
matches
–<=
/span> If there are no possibles, good and n=
o match
accepted auto=
matically
•<=
/span> No review
–<=
/span> Good and no match accepted automatica=
lly
–<=
/span> Possible treated as bad
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0017.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
How it Works
Customise User Review
=
226; May need to see more than the target table to decide on match
&=
#8226; Can also display associated tables
&=
#8226; E.g. Address, Contact
• Can also select which fields=
from associated tables to display
=
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0037.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Example –
Operation Tab
Select Fuzzy Matc=
h from
Match Type &#=
13;
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0037_image006.gif
Content-Transfer-Encoding: base64
Content-Type: image/gif
R0lGODlhGgJ0AHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G
RklDRTkuMBMAAAAHdElNRQfYAxUUNy3cKR5yACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA
If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh
aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF
OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAHgfNAGQAsAAAAABoCdACDAAAAMWrFcW9krKiZ7OnY8e/i
////AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDA/9otdz+MMpJq704W0G6/2AojmRpnmiqrmzr
vnAsz3Rtk8Wt7zw/CIagcEgsGo/IpHJJ/DCf0KgU6Zxar9is9tjrpnIEQHgsLpPP5jR6rW6z3+44
fC6v08eEn2bP70s4BAp+g4QagIKFiYqLjIBejyI5YpCUlV1iP5aaHz8Km595QGCgpKCZpTyjqKus
IKetPZ2qsDuytLc6r7gwkru+kJiOvzO2wzXFxskousoosx8A0T2TLdQn1tYd0dnbIN0e3NreYdvd
2R3MzSzI6i7s7fCh8Se94+I25yv5JNj2eP/UAoKzJ22gwXsD080z8W7hiYYOjSmMSODZP4Qz9qXQ
KEL/oEBoF8+ADDnJDMZ+IZiVKziCI8ZqIVyKeJdPZkwTZVZmnCnK30iY+ljqMHmwhE0SEyPWK4qn
HDSWJr+ZAweVnLeC30Te/OiTaUmCAH92lCc2ZNmzLo4y7IlW4z6OX4emZMv05UYWXPEaJYnC7UNh
FD1YDBe2sNB7cT9iBYv4rcGaY0cSTozWFWDCkTPHUFuCJje/mm+a3WnZ09OrafV1vdvypU3QnQEH
rshX8mOnF3FTRuwVYdzMv9syfjwQZWuV/rIGxCptuUdsz28LPRzKdPHr2piXXEw9r+/s2okGrz5L
PECoWcGrF2cc5Hbo79c3JZgeN7n49+fOBjF4+PjC//MFKOBkxLWk2zjhEGgbe5VxcplO35m1m2IT
ZsebYS/RFNY5u5ExnnOLuYZggR5o6JFo3v223WpWAVigYiJiaFeH2STl0FIHcaVihAHu6OKAdsWo
Y45FDUlVg2Mgl+OB4FV4oYswApiPhiKB+CSPWGKJmXkOWsebilL1JqNwTVrZFJMKAtlkY+mRtV8H
Fsl3H3xFKneekUt6J2Z+T33G4XQ+yaQkiSQ6qSaPNJ5FZVQRfrgnh0SKxWWJdH35pI+FzjiiphdC
WluUav5H6ZuCjRYaqbAE05WPrF7aqKuhZliplK9u+CiKjgZaWnmRgpqmqL5mCqRxRgZ7KDqyBRZn
a/+o+jKob1WtyaB8OhYrrYW7smjmmZgSeuR74EbaJa+izXltnnVR22efFH44XX3K2cmng83i2Cw8
qs6jFkTA3NAesl6mth9n6yRL0bL3qmPjMPvOagnBBqLFrwoQ/1JxCgvP04sdHN/R8ccehwzyyCK7
mTB5J4+bMi0Zx4PwysO0TNHEpNIMsyUyt/Pyzbt0ssXPQAct9NBEF2300UgnXfTOPO/CyNNQRy31
1FRXbfXVWBfS9NZcd+311yEwDfbYZJdtttNnp6322mx/InbbcMct99yl0m333Xi3vXPWfPft99+A
By744IRjfcvehSeu+OKMN+7444sfTg/klFdu+eX/mGceOS2Ia+7556CHLvroC0huQgQBpB7ABKsT
0nrhrz8de9Szy55I7bVjgDvUuZMueOvAM9J7BKaXAEHsww//wOzBD658Bc8XEP0g01NvvfR7JL88
79kTXr3wFjRvO/Slcz65A8hL8D3zC3w/tfvbUwC/BvPTf/382qPPvf3O+z29+OAj39so0bkG9E51
DHgdAhOYOuk1sH0NXN0DIZi7BTpwghdMIPYymEEFTlCCzHugBRmIwRFSEHkfvCDwUihBB0LQgCU0
IQexh8EOurB9DESfCD9oQQ9WkIUorOENKUhEEgZRgytU4A1jmMQi0vCFy+OhEnfYwibicIPBY2L6
/674RCYSsXg4OF4PNYhFMk5Rf0vkIvuuqMQNYnF3ZXTjCrnIRjLaUXxrjOMb68jGOaZRjmpE4x7d
2Ec+ApCQfIxjG48HRTyi0ZGIXKQZ4bjDRDavjSKkIyAxeclGmtGQnaTjIkGoyTiCcQQCVF0mVXjI
NXLShJic5AKDGMpYahKSdzxhHpO4Sj3i8pW93GUgDThMSd5xlp9kZRSDOUxiGrGVx+ylCpvJy0uq
UpSMdKYvLZnMUG6TmFWkJjIHCIkC2lGPydTmLYupvnQeEpCGZOc64ZlLRGrznbb8JjzhGEl3PjKd
9oSkLfP3TWM285z79Cc3EwnQeaozofGUpzdxif/DcELUlOY7XfwWKlAk/nOh9cznLyOqT5DKs58c
VegoVYpQkX5UkfN0aUkvSlGYMpSm1MwpRGUqTJ7qtJYK9WgLcbrBU0ZCjF5UY1L7OUohzvCaJDwn
VJ/oRINaEYZLNSJW6/lUrvoQq7hLYSmH6ssKnvCsSv0hM9EKw61KdYRQpaVOZ/hGSTq1h2LdpFtt
2lQhrjStSjRq2EZXP8oV1neI3Whi/Rc1wfKHsIstZWQnK0DKVm2qT3PsByzL2c569rOh06xgQEva
0pr2tH4TLZxQy9rWuva1GlBtRWBL29ralrWyva1ud8vbxea2t8ANrnAp99vhGve4yO1bcZPL3Ob/
OldrGc2bdKdLXZ6Rs7rYza520bbd7nr3u9wFr3jHS14Clve86E2vDK6r3va6F7zsfW8rBkDf+tr3
vvjNr373y9/++ve/AA6wgAdM4AIb+MAITrCCEWwAesh3IT8QgIQnTOEKW/jCGM6whjfM4Q57+MMg
DrGIR0ziEpv4xCgecQEafLoHz8NnSouxjGdM4xrbOGgZEMCKHexieMD4xkAOspCHTGSgrZgJemCx
8XrsYyAU+clQjrKUhbzjv1R5yUxWmJOnzOUue/nLV7hybMSMyixrGcxoTrOa0UzmESSZx2ZOxo/X
TOc625nGbeZJnvkTZ2XMeRt3/hkAiDDoIBQ6/2mHPkKiA83oPVvG0XWjGHVqcLGLrcbSb/rxoRcN
BU7T2dMGALUSRD0FUjO6zpCmVKppQ7F0wQDTnIGNq7cG40WbWtGnBvWtjbDrJ/T61GxW8kpY8uYW
s2bWQHlBrPlRLrDVmtehNnQ0hgDoUE/b2pwe9LWlXehNCyHR2uY2tbdd7Wh3u9yGxja1rT3uc9v6
2uCOtrTF3W12fxvdwI6ymCGErFW/bTLwOhGfpqKuw0ilKs6hlrzm1bRnFwHe3354uuVN8XnL29ve
nrjFM47xiNs74x5/98Q5TuiQj/zkF9+4xn+dbzwrWU6h8HerFxQqTyWqRb/CVl1a9SOYObzk3P8m
d7Xdve2VB73e4bb1vYcO9JQbfd0Vp3i9Ub50oXu84lMnucZbDuU2n6PYWO6Lf8p0kjDFSkjeuhPP
+c2zn6cb5FfPOhK0vu6kNz3bd3961Kce96cr/eFw1zrdWc71GK865i8v87Fh5SkZ8fxTaX98h7qm
aZP73fJwl/rl7Q51zWt+8Fen+uVF73m5O930To964Yd8eLDjQDWIqpXjZZ9zCdEeVg3fsri3ju5y
hLzoeu996Hlf9HIbv91//7vUi09oiEd80/HmO/SBv3oqJ97NOr5+2PDyru7XCeFUwRO09MStcI2f
8rqvvvo7vX4itz77cH51n70w5/bbH/n3t/7/MuBv7M3Mvwv1l38COIBAVgABxn9h9389k34E2IAO
qDQhJnMK6CzPVYGupX18NoG78IAc2IFSFn8aGIIi2DTxNYImeILNUIIouIIsGF0t+IIwqAwqGIM0
WIM9MIM2mIM6GAM4uIMPsWBAGIRCOIREWIRGeIRICIQYuFk++AgRlmJQGIVSOIVUWIVWeIVYeGIS
2ISxwIAe+IVgKAU5toVcWAteGIZomIZGcGRL4HqKV4ZmqIZyOIdE8H5kCIc2EIB0uIceaIdLGGl4
mIdnyIeE2IB+CIJ70WyLxy5twmR6WIiQmH+H2H/XcCqu5hKYNl61thJchneR+IlPMIkJiBOf/8Fs
logkLuZ2Q6ZroNiKUyCKr3cXAjdw2sEejvEd9sFw4KWKQsaKrviLTHBlw0YNbhgJrTaLL1IcwEIk
xiJevMhxQwdogfdx4AZv1oh0JFd8+AaMarhvuViM28cajCItuTIa/cAqufhdm8h0W7d3nrdxfId5
z2d6zpd53JiGZNYm4JiBYlcltbIlmjGOAlJezxh6yhdunQdyvpd6owd69ziHXjcXd5iIY5Io5AeQ
uLeLW+aJ78h77jh6p5d3qSd9DwmRf6hqJ8lq/Zgc8mJ25siS3kdeBflxTTd870iSI1l6IEl4JXl/
sPiGFoOKMrmRvIaQC7mQqqeQVfd7OImT2I7Gkz3Zfj9pjBaDGe/1iFcAlUqjlVFZfVMZjoEoiEFD
fb24jV3ZgV/Jj2FJA1h5lm5ZZAYIYAgYi2vJloP4lngpZBGYkj1Yl3lggYB5WnzplzSQl4aZb4hI
mIoZln25mI4pgo35mJL5f5E5mZaZZZV5mZopX5m5mZ6ZXp0Jh0k4mqRZmqZ5mqiZmgCWkgkAADs=
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0038.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Example – M=
atch
Tab
Specify the base match criteria
• Sou=
rce and
target match expressions
• Bou=
ndary
scores for no, possible, good matches
• Clu=
ster
Match covered later
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0038_image007.gif
Content-Transfer-Encoding: base64
Content-Type: image/gif
R0lGODlhNQLuAHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G
RklDRTkuMBMAAAAHdElNRQfYAxUUOwlMn7WvACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA
If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh
aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF
OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAMFiGZkQAsAAAAADUC7gCEAAAAMWrFcW8AcW9krKgYrKiZ
7OkY//8a8e8C7OnY8e/i////AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQID
AQIDAQIDAQIDAQIDAQIDAQIDAQIDBP8wpUWrvTjrzbv/YChukjSeaMopZeu+cCzPdG0Xg6rvfD/a
wKBwSAwuFMikcslsOp/QqHRKrVqfA9N1y+0+jxJAQkwem8voszrNXrvb8Lca563b7/hrtsjv+/9g
f4KDhIVFOIGGioJgYouPgjiQk5STkpWYk4mZnJ2GiCyeohOho6Nil6aqpqmrrjSbr7KuoLOUjbaY
rbm8g7u9r7HAw4+1xITCZi+OQswxZADR0YLOJah7x9lBv9qeyd3gQ8bhRbgt1WEy6Onq7IbrCdzk
4fLzmqXn04/wNfzL58v0WRMYhmA1RwfHSJOmrMS4ggtn+HNXBN1EGMkIKmwHwx/CRRb/42GjaI3P
RRcM9zUk+cxPPXuPhDE7GYRmy5oAczacWdJdwo09KVZ7uLKozn/UBpkryXOmvpRQgeoMyS6iwmk8
jYpE2bHikKxEPBY9ye/iS5iKYv0cZLMrznRg4XL9SXfn0aE58I3l6PZPWxkZ7VL9CJdw0IWG18qt
ynWXRo1A2ip+63byzb4yzqItpJbrVWcp1VyFuFMgNJRPTWsVrXVd3ZxlhM4guja0U4RYBzYFvbun
1YIvljJOHHUvybg+jwoO2sLxctIQD6Zuqnxx6NHYbR+Pns/0dOjNR26+59m3+aqDGaPfbldqecPV
jb+G74824sMsCScGrky//uT9uRCY/2j7BTjVe0i1x1xsezlHnWfIFfhYRwXCBiB8BmaYnoISaDYe
I3q91p9VvD2lnoYQntcXhizJl+JiLTqUV3mlFfeZelmBBdp5OmLEQm0q/gcjkBBiSFWLzhGoW4Un
sujakrf5V5yIFZIYHV4fVtKZhSfih+OFzKG42mdG7iVikyvVN6NyToIpZlw9isnSgO9pl12YGeYz
4nRxApRkbBKGGSiNrB0pJJdBumkgPx5m2YdMXr7p5aFMSoqZnH3uCCB/MXa4pqBu5ohme5SOiqFw
nfxFg6YvJElqooiy+KqipbIap6hfktSoo+XoBd6Nui2o3W2R+qTapcR2h5pFBtGo5v+Whx0LbKHS
OjUpdwMF56snqlIY3zWEGstngnYGBKdBdtr462/T/oYbOrvyOsQ3CcrbC1Hh2ISqva2KF5a83QIR
L7820Bsuwa/gC46+2yJsxsD1fhjwDf46zIfBFg+jML+4xOGxHB+HDPLIbWyVsS0QnyxgwyoDs7G9
GBOccsuKzEyzDzjnrPPOPPfcM8sOI+Lz0EQXbfTRPeSh9NJMN+30007TDAPUVFdt9dVY5yH11lx3
7fXXYIct9thkl2322WinrfbabLft9ttwxy333HTXbffdeOet99589+3334AHLvjghBdu+OGIJ674
4ow37vjjkEcu+eSUV2755Zhnrvn/5px37vnnvGQt+uikl2766ainrvrqrHNRQ+uwxy777LTXbvvt
tr+O++689+7778AHb7ruwhdv/PHIJ6+87K8HsITzW0Afu/RJUH+H9V5gL7z2vEMvvfdccH+6+FJY
T374SIC//NXNPx996tyff70d6iNvvtLy0+++Avkz0b/o/3tC/fIwwPVZrX1KCGD64OcEBb6vDgUs
3v0IWLUJOpB/srvg/jQowAUaEGsIrF71qBeAEj7PhN9LXwm9t0IMenCBJuQfCWPYQhmCL4YudB4O
bUhCEcJQhgnEoQ7Nh0IgjlB7O6yhC3OYQyHu8IgiTKISbajCFLLQiVdMoBGlWD8i/9KQhzQU4hKh
SMUfBnGAWYQhC4+Ywirub4k6pOIQm4DFGbZRfXNko//EGMc0YnCNvguhB/HoQx+2sZBmHGMYX2jI
F+YRj4Rk5CEf6UgVMrKJg0QkE+FYyS1GUZNa9CQnQxnKL2bylCO05BgT2cNTRhKTdOzkE+94SVia
kpaj7OQfB1nAV3bRlar8JSkBaUpb1jJ3NFjlIcG4QUROcJfDLOQKXynLal6yj5tsYg2Xmc0rPlGR
jUSlF785TWsqU4+59GYvpYnOOEZzk+o8pjhrOc3v2VGY3eTlFHfpTl/67531BOYouRnQdIZTnsic
wTnZ2UBdPhOaDM1nNq2Jy3Nic/+g/7ymORtqTnwitKIelegk6flGkCaSoqgE5UEjiMSRGhSjq9Ti
Rf2ZUZiWcp65JKlDNRrIZL40pJDkKSkjKsxf4tKkMoUmUgna0WbCtJhW1ORSpdpUnD4TqTE9qlU7
aFOG0tSlWtXoTHEazqnCc6Ul3elWe0e8fXKxpkXkYRW5+VK56hOljtxnXe3p0qTmtaVnDOJElahX
u05Sr96UJGGT+E44EpaO2xSnGIX62D2ica5qLedfY7lTutYxsAI9LDknq0jSGjGmsyPe+GbHwQ+O
rrVRgC0UZNs02uLBtpx17RZUS7pvok6zumVtYW+L2+6xrrh2De4VeKvc5jr3udD/je7omCvd6lr3
utjNrhKoq93ueve74AUed8NL3vKa97yia6tpWQu7CyIXf1eIX29/997pTSF/7kUfalPr04qWj2ry
/W5948vR2GZ3wO2973/1m1uu4k6QEF3w0wLsXQRXgcKzPbBz8SthAhfYwbeDMFnD6Ed3qlGVbixj
ZH0b2Sg+1o+nPS1fXQxX7OUxxVPsJxeLasYcDxe4VpwlFmnczEVitsdQTfEZ7ehiEn/ykUw+MRnL
WL4oK5nISk4saF98wiGreLL2rJ2IRSpQWKZSlDflZDHxekcen1Wk65yoKP2LZjfD084UtrMueclT
IxfVqJ+krCy/SkyWBrOSdM0o/55PuFamDvSqGw0tQlM3Zny2sqA2JmqLIb3kMHcUyG8ks6DhGmm+
JvmpbAypVw9KzxYvFKxozWQ8AapZs+7V1b0EbnIVu01dP3rTVO3qoHEN7EmrDsL9dCardWpTauYU
taRV9aixKklSC9uzsVZ1opst1KrGWtQYjeCq08rtqtLZgdgusKGfredIi7qV/FUoque81sa6OarT
rndYI0ntN49bzrB2JU0lam1iprXflvZ2Xzlt64TrG9EqdSrCs71ncP/7q2WOnXoP69hSrvfWYD71
lmVa2StLUZrRLmmmN6vsKSc3rmjc8TV9zO7PsjuzJadyaW3s44Wn3KG4nvJw9/8I2isDvc3kFDpk
vaxPX277dONtroWNu7SpV33C6L1w1qMQdeVaHXdfp92Awx5cshuw61tPu9rXznYkoL3tcI+73K/7
9rnb/e54V17d8873vvtdzD79u+AHT3iNB77wiE+84g94+MU7/vGQd13jI0/5ylve7ZO/vOY3X/i9
c/7zoF+750NP+tKHd/SmT73qqwu61rv+9bCPvexnT/va2/72uM+97nfP+977/vfAD77wh68KdhH/
FIiZ2PEDx6rlm0L5l3I+3ZovfW4pAvrVBxs8yvWRdwUr+6taFlOwlR3IgP9t7oKViYZ0fr4UiVad
aj/64c8hMskfWTbKkZXuDzf/TeFKTvF3f7ayKW3Cf/OnfvzRI8jBfwOoIINigG7DLteRG2niHdjn
e9KxfuQ3gRDYgbR3gR4YgpJjfCJYgiZ4gvRQACq4gizYgi74gjAYgzI4gzRYgzZ4gziYgzq4gwsQ
AzpTMQ6xg0I4hERYhEZ4hEiYhDbYg2mDAwPwhFAYhVI4hVRYhVZ4hViYhVq4hVzYhV74hV6oAEwY
HIXwEk4IhmiYhmq4hmzYhm74hlgohmojNEhTh3Z4hzwghxhRhkDoKXj4h4AYiHaoh2hDh4J4iIg4
iGMoIHw4GzmQiJAYiZLoAYTYDNJyfdHXD0JgiJPYiZ6IApXYAov4B2b4iJ94/4qoiIehaAP/p4mU
ER8x0hacmIq0WIuraAKNmBmmWIu82Is4c4sSMRev2A/S4X6wGAOz6IvKCInAOIou0YcisYzSOI0h
AIzGOCpAARWqsSMPUn7edwYnkYzUOI512Iy5iIy7SI7qSI3WeBmxkiv6J4wwwiNMISsuII7rmI88
Y46EUIr6+I/K2I6ZWCWwsX8WQhzrRySOCJAMuY/OiIv9CI342JAUiYgCGTGAsiAqgifdZyrsMSYy
UpEiuQP86AsSmY4jmZKAeJHkgiNC8oCRMijdaBYoqZI2uQElGQkneZM8eYcsaS7RUhoFuYBPsoHQ
sYD90pNKmQE5SYo7uZRQ6f8zP8k1ExmVI9mUz7iQVrmVv/iQY1OVXNmQWMklaqKVYXmWKTCVWwOW
aKmPY8kH/tiWclmNXik2bDmX5PiWh/CUeNmXGqCWUnOXfimNekkEcTmYiEkBgEkzgpmYvdiMSsiX
jumXi9kyBbB6WeOVcPiEs4GZxVOXYTOZFCkLojmZKHiaqJmaqrmarNmarvmasBmbsjmbtFmbtnmb
uJmburmbvNmbvvmbXWMAwjmcxFmcxnmcyJmcyrmczNmczvmc0Bmd0jmd1Fmd1nmd2Jmd2rmd3Nmd
3vmd4KmdNBCe5Fme5nme6Jme6rme7Nme7vme8GkA4xmf9Fmf9nmf+Jmf+rn/n/yJnvPZnwAaoAI6
oARaoAZ6oMP5nwi6oAzaoA76oBDKoAoaoRRaoRZ6oRiaodI5oRpqAATwoSAaoiI6oiRaoiZ6oiia
oiq6oizaoi76ojBKAAeAnAdQozZ6oziaozp6AAKgnDH6o0AapEI6pERapEY6ojNKnByqoQQgAE76
pFAapVI6pVRapVZ6pViapVq6pVzapV7qpQiQpMYpptjZpD76pWiapmq6pmzapm76plkapsW5pBna
pDt6p3iap3q6p3zap376p4AaqIKao3J6nGR6nWaanHY6qIzaqI76qJAaqZLKqIWaoDPQocW5qJO6
qZzaqZ7KqZVanIdqnYmK/5ya+qmomqqquqqpGqryeanCmXzcCQDHSavRaavTeaqsuqu82quUOqrC
CazUWarHqau+eqzImqyteqj/iave6azDCa3EKa2xWp3GqqzYmq2r6qrDKay52qOKKgDaOq7kWq57
6qrNGp7RUJzripzUagDv2pzXaq70Wq9+yq3Bup3Eapzzaq/++q+qiq6wCq/Giau2uhCxKg0EW63R
urAEa7DtqrDwGrETK52nCgAHgLE2Kg0A27Hliq8G4K0WC66mKq4bm7E3qrEpGw04yrErq7Iom7I1
CrMom3w067E466gCKwPRirAOC61A+7PTKrTSerAM+7BGC50XG7NMe7M5+/+02yqsIhud+5qpJjuz
TJu1TXuyWNu1WyuzGQuzYgu1ZKuzzDqwRduwaru2tBq0D3u0Ppu0bEu1Jpt8Wuu0ZZu3kgqyU6u0
JFusdYsYWKuyNIuxhXu3Xtu1hsu1iau3jqunOxsDazu3R1u5bcuu1Zq0Bsuwbuuwzqmpi9u4G8uy
g6uxpBu2p4u6J0u6hPu49cq3+vq3/Hq1oTu4jAu2LZu7iFuzt4u3rvu7NRq5MDC5nCu3lXu8Qsu5
aiu3l4u8ywm6X6u7Mcu6puu1N2u61du6wEuusKudVUuc0Ku906ujTnu4u1u9Weu72/u4wvsCxJuw
Cxu3Euu5zgux7Rq/FOv/vGe6urfLuOj7teK7ENZru+s7rt2bnd87nOHrv6KrtY37v4rLv/1bwL/b
vi7QnfEan3Zqt4irvQE8wADMtbVLwcp6wGUqu1aLui4ruB2cu+b7whLcwCSstxbcAtt5v/q5qCMc
whEMwh4swgw8w9hqwgWrvOG6v7z7wCAcveLLxCuLu0LMvmfLs5iqwHXrwC47s6f7wSr8sv/bxFHs
q0RMqigMvlcMxoSbuqr7sjmaxbsrw2H8tDVcAlVsxaiqvniKx3GMqmNsrWVsx3scyMg6xxJQx8LZ
r5Cqx22syIIMqlIbu0jcyJIctXM6sFWMyJMcyHxrpH98yFebyaDsyJVM/8V1TAAIcMqonMqqvMqs
3Mqu/MqwHMuyPMu0XMu2fMu4LKxw6qQ+isu+/MvAHMzCPMzEXMyzPMWSa8ihvMw2Sp/M/MybOsrJ
bMjUXM3WfM3YvJ10ms3c3M3e/M0dus3gPM7kXM7mvJ/ifM7qvM7s3M7dmc7uHM/yPM/0bKnAec/4
nM/6vM/83M/+/M8AHdACPdAEXdAGfdAIndAKvdAM3dAO/dAQHdESPdEUXdEWfdEYndEavdEc3dEe
/dEgHdIiPdIkXdImfdIondIqvdIsPX3X4RUBCJLWZxLOYn6FYBPJpyzdUSL6Vy5QAoIR4wdkARkv
jR1XQglADXvUR9Mckf/UfaB8zbIpT+2O4feOspEmXVKAhLB9N+2KWH3VHIJ9XJ19Sw3TN+HUTE3T
rSjTXn0wVM0gWX3V9JEf70DVQl3VG5kneg19Y119rjGB6NJ93Jcbge0t32fUgPIY3zGP/7DWCZEa
Oq2Ngt3WrNEleJInWt0VkP19kl0YFNIbS4LXhFImxlGPnOKNR+kex5d+HmkdYZ2AUr0o47ce9Sch
E/GSo40bdI0iGvgM91HaEpgurL3TzALbLwLaZWHcSDkVvb3XH5mABbgfze18tq0usk0lR+0sCFIj
EzIrwejabBKTU7Ld11ja3xLXRiEWBDjeB7IsD3jbL5LXpB2Toe3cMb3/e/6X1y5S2ZbCF0Sy3P3t
3/ZN37OikHa93+g91+n93d59KLH9f5WCkexxJsCNgBW+fPnd2kqy2xB+3LONKfFtj3fRJwSOKzMp
2u391Rme4cfogKHy4f8NKwxeLSm+1LdCj+xH3bYB2CWCjQChI+ZX2ODR43UC4KBy2DVe33uiKG5t
1OTXLtlNJtBgfJki3BFukFHCihT4K+tCgi5ulHdy38J3gWh9gC19N3xd5me+5mze5m7+5nC+mvU8
53Re5wTaC3ae53q+5/CJ53z+54Ae6O/MC4Je6IZ+6M7p54i+6Ix+6Ire6JAe6Xn+6PJ8pEfat5LO
nZZupJgOzpQez026/8tuCrKZ/p2hLupsSurm/OnujMl7O8udXOqm/sl8DOv1zOrt7OqRGqZ6msCy
Puusyut56uvqjOvsrOuQquqe/OvoieyPquweGuvnbOzr7OxmW8RmzOznae2Nyq3QSuzTTujK2bnJ
Sa0Z7K45TOuf6qrzG+3Teu7WKavUabz6O7TYDp3wDp/c/qvsisPEisOzCvC3irn3/pz5/qq5sJw4
DO/mXu7oLp0HP6zq7qnQXqrMi+8KT/DVmbYZX/Aa//EG3+wT36kVT7IXH/IPT78Yb+8gz/Itj5zU
/rb13rP97vC1eqsRL/FsrMVuLKgIsKImb8TNKfAen/M3//I1/+427//xzEn04HmxWyzA3Q70yzvz
SX/07+ucQLv1S4/0xhnzzfuzAh/2ZB+xZm+0Tg/yiBG7QczIfMqlSq/yXT/uBN/uC7+5E3u/9lvE
m7v3eZ+waJ/vW9/ubO/Dkgr3NC/3Kb/4/e6sdk/4ZC/2B3v2mXvuYG/EeN+wfY/tF5+/cx+e0NvD
yW7rTP/55b72yau5mF/1yav5rl/3cFuxip/15Rn647vrpO/1pa/xEov3vk+8kc/xnU/v0jwLHS/z
ma+8zNv7x5v8jI/6CEy7ItzzPr+nVTv5Q6/1WO/8jh/7+Av5mQu3zE+/zo/1gJ/2ZNz21B+owo6n
1w+/TX/8Qn/y3B///pKv+iyfwZdv//WP/N5P7xAAzJTTXgsq5t13QjjGQwPIc0xJtnVZ5PisEKvu
Odu+PfN/II4yNPQuOOEmaQPONDlolCZSqVKr1UvrikFrR6Kx8/T0hEUiWr0Oq89LcLqToNftd3xe
v9fndmQlprS3tqFAKTGpqBCUxpasrciDriOyia9BOb9NjkM4OLfMuDXCUMMmTkVVDEaUE8gSSdlJ
mcodTFJNJx4dUU/UQ1PTwOA5vmPkZLzUQUvUZssbwOfV6o/W2KrHWUnK0UsBnkRrNtvK8zCTIGdd
UvX0UnL5HGwWWFhumNpvA1yb8WrqlDh7R6Fgu4HRDMYzpszhw2Xz/yROpLgKGxZt2fK98HYtXEWQ
IUWOJDnFUTaMGznu81jS5UsoEGXKhFnT5oV6JuxpUKkFAQGgQYUK/XjT6FGkinLydIWv58+hUYEW
TVpV4kysyqxulVivp0oBYcWOJUuV61m0I71+zVfWrdi0cWNmpbtH7l2PbPVyw9vX7yIqewX7ZPk3
bV3EEQ3jJYDA8WPIkSVPplzZMoLFmRc3vtzZ82fJhTVbTVyazmi5g1VrQd067mrYLlxvNV169m3c
uXXv5l2z9m/gwYUPJ17c+HHkyZUvZ97c+XPo0aVPp17d+nXs2bVv597d+3fw4cWPJ1/e/Hn06dWv
Z9/e/Xv48eXPpyRf3/59/Pn17+ff3/9/AAMUcEACCzTwQAQTVHBBBht08EHrIgAAOw==
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0039.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Example – M=
atch
Tab
Set up the User Review
• Can choose
• No =
review
– use in batch mode
• Only
possible matches – accept good matches
• Goo=
d +
possible – review all matches
•
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0039_image008.gif
Content-Transfer-Encoding: base64
Content-Type: image/gif
R0lGODlhWAJIAHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G
RklDRTkuMBMAAAAHdElNRQfYAxUVCy2uGA26ACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA
If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh
aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF
OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAG9vRwjwAsAAAAAFgCSACDAAAAcW9krKiZ7OnY8e/i////
AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDA/84utz+MMpJq7046827/2AojmRpnmiqrmzr
vnAsz3Rt33iu73zv/8CgcEgsGo/IpHLJbDqf0Kh0Sq1ar9isdsvter/gsHhMLpvP6LR6zW673/C4
fE6v2+/4vH7P7/v/gIGCg4SFhoeIiYqLjI2Oj5CMBZOUlZaXmJmam5ydnp+goQUBkaWmOAWPAqQc
ABGuriKxT7MKtRoAuboXtyC9Ib8Vu6c6qY6rHcEDsCPKOM4Nt9AT0jPT1BDXDrPaxCvGjcjJC9y2
zUHd1eMM3STtD8Hv296oqqyt5PnLy7XD+7nw/PkzR1CgPoL7CgI0t3Agv17q+LFb+I9dNHIN83HL
iFD/WkOK/2KBHEYy48iT8OjdAMdIHL6OtkTClJjwoEyENZkVPJiTZ0KOyiLu/KkP5EODDDXCLIeT
qceYOIeWA1o0qjyVJVgucomPGdOfum7WnPk1ac+zSnUeJbvNYcR+YaOO3UiS6FGZXi8OtWmz7tiz
YcvKxRpDqyKuG/J+FcvX4t5qYiNfzAu4quO/QgX/xSxXJ+Okatledmr57WDOhGsYToQ4MU/Sj/Xa
3bxY4eSKlffOHF3a8uXYoolSbmwauGTYdq+mPrEaUWtcr/vWjibQaFOUEF/7RRvT+kPqEzW/HSmd
d1vB09cqlNx9ouzlhe1JUQ6/PpPm1LybkBc43Yrn/0noZ9+AVeD3ik8S0AfdbzYASOCDqRmYEoMH
uiBUg/dAqOFyEs7jYU4ifTRViH2F92FHHOH2HVqhUeDghjCW0uF7xElVFInJAYdRXEsp1VN6F7wY
45CNzEghi44hp2R4RvWzo0nrQdmiBUISaSUiRvqklpPG1djYhL75+FlFU1ZQpQQCpKnmmmy26eab
cMYp55x01mnnnXjmqeeefPbp55+ABirooG5mOYGholE1G3s5Lkojo0uSuZmZGWqwSgCYZqrpppx2
6umnoIYq6qiklmrqqaimquqqrLbq6quwxiqrpgQgGoGtK0K1UZIUTbfrjieCyKWw5k0awZnHBiDK
sv/MNuvss9BGK+201FZr7bXYZlsAAdx26+23BARQqwi48oEsBKtoq+667Lbr7rvwxivvsrV6ssq4
IZS7x7kPpDvvvwAHLPDABBfcLL4T3KtvAwvnwa8D/hos8cQUV2zxxZ4gjKa4DS/Q8R0PNxAxxiSX
bPLJKFOrcbIrd/CxHSEzMHLKNNds880kt9wvx+S6k02wQI/pH40pxLxAxP2BAgC0ulzStCVPTxKY
tEtXkjQlUUuddVhYax111VZPjS3YOJctsc4Q85yvz2AiSDSCF1KoIAZGK4A01O2CTbbeVnctdd9M
4w0433/7vXfhhxdAduHTLu632ZATjLbIaoPwsor/cmPz86MVHnlC3QPcDbi6i1ddOuOIC+7s6X2z
nvjrqJvudLWOox757fMi3N8sCvcsy1zVWVdXryieFCJdi6EUAuiiP/4033rnwjjhtj+e+uCqYy39
39t7zXrXrmNSu+yGz67J0tt3r3j67Muu/ta14y7/wSwFJnPlH7wcKXoa3eS/lh6CjQCXV6kMIE1s
igOfAhPIPeeN7nmCC9/ozJe+6UFNbN/jmva6ZzoNMjBsWdOaCD9Yvg+ij3yEI9/8Vkg/6tyid2sD
hm8YZZXecEdY7Dke8UTAPGXFboMVRKEG0ZfA712vhEis3hCRaETrkdCJ14Nd9sxnQiAe0YLr+xoL
/7fYQqLB0HKy4FGkAGijG+bQhkDjQA+dqMIFtrGBRJwgAyWYxCemkIlTtF0b93jFNz5RdXeMIiCr
R0guGjITk7tfIjHwMcjMUDZbKiNq9pcoAnqgeUekngrdV0QqctB6mpRjFUdJvUKGMokoxF4eH4jH
OS7QlYI8pCw1sUi74c8DjdQLj9RjotwgL4Al2WGuaAKCNepxg6z0WjKdJr29qU+ZQIzfEqcXwvhl
8YLv02IWOTi1qzmQmp+85ijFOcJZmtMStQzdLV0mnw7M7JzwjKc81ZXOL+avnWr04Tz3yc9+Oque
6+TA5ehgTH8a9KAIRaedArqBgc6hoAmNqETleZCqdFbAoXJgHrg2ytGOevSjIA2pSEdK0pKa9KQo
TalKV8rSlrr0pTBN6cswGgfQTfSmOM2p78JRwCv5NBEFIJRQh0rUOvX0p0glxKyWytSmmiqpUI2q
VKdK1apa9apYzapWt8rVrnr1q2ANq1jHStaymvWsaE2rWtfK1ra69a1wjatc50rXutr1rnjNq14B
kQAAOw==
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0040.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Example – U=
ser
Review
<=
/span>
Shows possible matches at run ti=
me
• Source record
• Possible matching target records, with
score
• If configured, child records of selec=
ted
target record
• Allows selection of desired matches
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0040_image009.gif
Content-Transfer-Encoding: base64
Content-Type: image/gif
R0lGODlhlQL0AHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G
RklDRTkuMBMAAAAHdElNRQfYAxUPIBSW3F59ACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA
If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh
aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF
OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAJZkttHgAsAAAAAJUC9ACDAAAAMWrFcW9kgICArKiZ7OnY
8e/i///h////AQIDAQIDAQIDAQIDAQIDAQIDAQIDBP+wyEmrvTjrzbv/YCiOZGmeaKqubOu+cCzP
9GTceK7vfO//wKBwyKsViMikcslsOp/Q5mFKrVqv2Kx2y+16v+CweEwum89oLibKbrt3xrd8Tq/b
2+m8fs/v+/+AgVNrOACGdYaJbgB3OHEGjDmROpNMlTeXjTyZmphJnJ0/VABlpIKnqKmqq6yDF4Ww
c5WgS7Rvj5ectkGZu2+gvqFAwcI4o6WtycrLzM0HhJCNs23EUI/RnptOvcLAxU3Vxcdkps7m5+jp
YNC6h9jR7oqY7rHZkPTy95Hx+XfXkwDjvdtHrxA/SowA6kuoaJ+kQ/gO6vNU0KBDePL4BTSYLeM9
hPP/CH7LMY6UoVEnDyQyxTIlS3UwY8pMBW2ivYSwLsKrt1AhxZxAB3b6x/OnQp8338VCqhRn046U
sB3VmdTh0ao/d061JzXoyBslX1YxeYzsFLPlZqpdy3ZMzaVeneZaKaluT6VCdYZzcm2nRZxT+12N
KpTrxWldFyauNzejXql0n2b1K3nwVwMlw54sR3Zly7agQ4u+8hbqZLmEdyDOlRo1Vzt9neadrW0y
XNNJK59enLvoR9q67MoeLtzr18xnVZZdnvZs89HQo6tjd9svRKyGi+8ezBR2jdSzRTK1fPt60YqH
gcdt3ZV7UNTEx2O/jFw5Z+XJzdpPLr2//2Y1CRYR/2X59COZTQh6FNJeTfSFF13ihaSaQK0B1pCC
2hFEIYa9bKjYQAPO0xGFB2J4HH/3qZSIii45J9Zz/8UoIyClXWYjEQ7eOASDdPCo4xxjwDjjkESu
UuOPSMLxXZK8+CgLkzYGWeSUVNL0CpRY5pBjllx2+U2VYIbpzJFe2rhlmWim+YaYbLapCplqFnNm
nHTWiYSbeObZhxF89unnn4AGKuighBZq6KGIJqrooow26uijkEYq6aSUVmrppZhmqummnHbq6aeg
hirqqKSWauqpqKaq6qqsturqCJ7FKuustNZq66245qrrrrz26uuvwAYr7LDEFmvsscgmq+yyzDbr
LP+xIABAwLTUVmvttdhmq+223Hbr7bfghivuuOSWa+656Kar7rrstuvuu/DGK++89H4bLQEI5Kvv
vvz26++/+uIL8MAEF2zwwQgnrPDCDDfs8MMQRyzxxBRXbPHFGGes8cYc/3svAkbg++rIJJds8smU
SgtyDSKjXEDLKMN8sswm01yyzSTjvIHKIa8cs88zA12z0DcTnbPRI+usAc8sI70CAAVAzcFKgOIM
tdSr2uwZq1YnwrXRVEedqtYShI2q0hkwTQPaKWC9MwVu92xB3BfQ3SnZE9hNKt5lw3op32L3bSre
WOsdKtt1I66C4iYYXoHjTc899aiAQw4q4CRYvij/5nmfSjjcZzudNuMokG1I3qdHffXpqasu9dVl
F5663V67rnrsrZOgNeyzv8677L6vjrrmfFaOe+zIHy927o5ybnvgy99+O+uCM8q58K8fTnT2nXsu
OgZqz7B734UHzn3cvJsPPeyPd37++iZ8/r7v1ZMvOPvQF7p77eXP7z73j7qe+/5nP/XlT1ECfN/l
tlc/4mmKdHmDYPwYWMDoGTB46Vsf1ejWv/vBrwTy654Bzee1+ZlNfxSE2wZF2MH6NUqAFcQf+xRo
vRQOcISe+pwISyXBqPVQdymU4QVjaEEcHhB+/nNhCELYPQAKMYkItKEL3ebEDwZQiki8oQVpuDks
/85QiZvSIRi1J4LwyYBvT/RgEdOXvRYSEYoOvAAT21i9NKqvfIeC4RbfuMMX2tCO1Cug7K4ouQEO
kozts+Lgvpc4Ri4uiMpTIAa3CLzhVXKIJxwBE6W3Rtx9kYRxXBsWn3dIUvaxhnWr3fOm90EhEnJu
/FMjIkHnulBmqodmjMEPE2VLDOySco5U1S9D0Ms+/bCYr/xZGYcJAmYWCpkVcOanpJnDYDYOmnKL
Fjb96LKXWTOC35xgN8dJznKa85wfkFa91snOdrrznfCMpzznSc962vOe9vxYx/JFgAD4858ADahA
B0rQghr0oAhNKEEFts+GPoyhDo2owiAq0YoWjP+iFs2ovzCq0Y7yU18fC5lCR0rSkpr0pBz1qEZT
qlKLsrSlEn0pTB0q05nuk6EhZdlJd8rTnpa0pjblGFCDqrGhEhVjRj2qxZKqVIrhNJ3U5EA/fUrV
qlqVqU2VGFazCrGtctVhXv0qw8Iq1omCFKrhBKFV18pWk5K1rAh7K1wNJte5EqyudgUYXvO60bN6
IJcwmGpbB0vYge6Vr/w6LGIDttiLKbaxj13sU/8qs21mQLABQMBJNVvYzi60XwD4V2gbe1HQihZh
iSDYaPO12pXuq7WjXW1rSdtXfcE2YbPlK0Zzi4DUstYQtN3XZDsQPuatALM75axnl/vP3Z42uHr/
Na2/eDtd2xYstiqF6G17y1roRte2ssUtbbULXH6FN7zQHe7UKmvcFCB3s8yNbwCcW13v1va1z72u
eLnrUe3il7vUtS95rYva8Ur3vwAmcHDVuzP2tvcEmNWshJWrL3/uy8IWzheGMyvfqtK3t+UNbYhB
nN4D+1bE2C2vgsGL4u4Ct8UZ9S+BVWzffvkXu7/FcYpPbN0XdzeoH1awiFdMWgYvzcEPVus/J7zh
JXMYwxJ2MmeV22Ge0ve8O/5xkaWLZRfjmMUzdjF/R+xSBI85wALGr457/OMhi/nNX55pkLXsZv4u
2K/ERbILIvzkJ1+YwhzmV4arTNUrs/nNdoYs/5cPnWAtm7fNYv4ymjcmY0hP+s5hju1KEjzk8x46
zjCds53rfGm4Gnl0QFMlC/gM6FZLuc9LpjKhURrmUdsavVuG9K0ZTd01c5rOMTazr2ssXASTmc2d
5vWYHR3qAwvZ1iXOV06Tt2eARhnKr8a2q2E965/W2tOILvVXGTpsUkMb2Mv+9bljKmx0E/ujQpY0
usHt498eVdTgTnSuv1lcXVq7z1Ou8IX9rGE/d3unAwbzrpmN2ITnGNi4friu3WzuMr/Wt4kWt27b
LXFob9reFSfqh2WrYoxjmt9R3cB7ESrrgxM2sg1/d8NgvnGJapzdMl/YqcGXcg2s/KAtd3lbaf+e
V6Lb1ehzRfrFm6r0su68kSIVutQD2nSxVn3cOdd51s269bjieb1p1d3Ux+7Pq3PV7FlFO9O77nW2
0/XrDQ67Jsk+drUr1e73dvvb9X5Xvvdd2miNOt2FjneR+31ghQfy4b+7eBvD/cj4jLzkJ0/5ylv+
8pjPvObZGa0BeP7zoA+96EdP+tKb/vSoT73qV8/61rv+9bCPvexnT/va2/72uM+97nfP+977/veq
jxYSBGCn4hv/+MhPvvLvIIACgOz5zo8+9Kcv/epT//rWzz72t6/97nOf++k0wMEIQPzGm//86E9/
R8n/fe+7v/3wf7/8499+4TuS/OJHp/73z///mzWf/vMXgAA4gAIYgOF3f+XXfwq4gAwoKuxXgAQY
gRA4gQBofx2Af3LXgBq4gRzoJ+RHgSAogSIYgtV3gIVEARjYgSq4giwoKA84gjBIgjEYfxaoQhaQ
gi2Ygzq4g6v2fzL4gzMIhNlngsNzgwnIg0iYhEooVQIQhE4ohE9Yg7VkhPm3hFZ4hUr4gU+4hVBI
gkSoPCh4hFg4hmSogi/YhVyYhgb4hdQ2AThYhnAYh/2nhWhYh2pIg39VhbQUhnooh374h910hndo
h4RIfVLoc2IIiIq4iK5Ch4P4iIUYfWx4WYnIiJZ4iXvThJEIiZB4iJTYh5gYiqIYRj7IiZtI/4jh
By7Et3ms2Iqu+IqwGIuyKIinaIpRmE4CkIu6uIu82Iu++IvAGIzCOIzEWIzGeIzImIzKuIzM2IzO
+IzQGI3SOI3UWI3WeI2/WIvaqIbp9Cze+I3gGI7iOI7kWI7meI7omI7qqI6j2I7u+I7wGI/yOI/0
WI/2eI/4mI/6uI/82I/++I8AGZACOZAEWZAGeZAImZAKuZAM2ZAO+ZAQGZESOZEUWZEWeZEYmZEa
uZEc2ZEe+ZEgGZIiOZIkWZImeZIomZIquZIs2ZIu+ZIwGZMyOZM0WZM2eZM4mZM6uZM82ZM++ZNA
GZRCOZREWZRGeZRImZRKuZRMGSnr+JRQGf+VUjmVVFmVVnmVWEmVTbmVXNmVXvmVYBmWYjmWorh8
ZnmWaJmWdUKTatmWbvmWcCkMbPkae8EaSOAZcoCX1LCX2zASTpKXQvCXN2ILdVkmc/kgPeANUCCY
r3Egi8mXw6AajakJjAmZtbELlfkEilkbgTmZTHKYISKZnNmXjwkemYkXpBmZhHGad5kkhOmZvvEN
mymanYmaUAKaGyEhv+ERAsEQfzGaNqERGiIidnETEREQIvEhFZGYyDkizfkbHOGbuvkQ01kgEhEZ
yxmcc1Gdx0mc2NkhGGERxPkQyWkgCCKe3bmbvQme2gkS0nmeHKGbW5Eg2VkEMwkUsvEeOWH/FbtZ
GOBRF49BHguCFPGhn1mBmdtBG5SxFPxJl/NRoOpRnPmJGxBqHQbKoA76mo8BnOkBoFVBFYsxoZCx
G8VhGa5BIEIAmlrxmyB6FSbKoQ3xoTFqmgOKmAdaHdQpoRByF3apHRhhIBpiHowRopMpoJAxo0O6
ocFRGDs6Ieahl7+ZIQvCG/5JoagZoJEhoevRoln6AyqaGO6hpRW6pNghoNyAozZqob2hmqzRo40Z
oD7QouyxoVdqHLjhoDe6plZqpGFKm3bZoGo6pD4qonD6A4UaqLDZA1/aoYFaoC9KmxGKome6p1ta
pmwaHpW6musxqAp6oic6H9UxpkQqp51a/6d5WiKaKqkPmqoLSql4CqFPuqlA8KWMoSAcgqIf8p9N
qpz4QKPc+ZzImZzDAKy/6hvEAZ8g8pzBGaXZaSLGqawc4hja4BPY6aTDsZxdCqZTeqR6SqySSa3N
Cq2AIZ7TOav3+RWVyZpxua7s2q43cJidkK2fYJ7uWq/2eq8+AK/4uq/82q92oq/+GrACO7A/ArAE
e7AIm7B0YLA9kZUO+7AQG7ESO7EUW7FSSUyzmLEau7Ec27Ee+7GtiLE0pX4kW7Ime7Ioyy8im01k
2bLnBFgv0HMPlIEOSLOzFDSBaLMLtEw66wEye0s9W005O7Qu87OYgktGe4Ngk2SWFUWp1P+0k4I5
oUQ7iVS1f6Iz6KNKZrO1tERFngS1H4C1j6O1ZNs6Xps/GKQ3ZzuFQAQ+Y2u2ZYtHsgRKs+NJupRW
MLtnkFQ3xFUpaPQ1JzhGasu3e1i4Hog0a1tEigtAJLRDYNtMiFu4+LO4DURtiRu4jFtMYuu4aNu5
nmu2kltHgYW3SRtNo2S1aeO3pxs6sIQ6bku4Jzi4gWI1iqREZ3u7cntELAs6uWu7Xdu1ues4t+te
YFO7RzS8TRS8v3tKxMuzuwtGsbRK/PO4ZzRKZZs8qha121NK0xtJnCS63otH2dsCtNu7x7u8HpS5
s1u85stB6HtHlZu6TdS8ktO+mBu/n4T/v4b7SM4bObAktxnUSdRbvU/LQllkvJBiOoorSATkuedr
R7rLv1XLuL47v/OrvlWzt+5rtRicvxGsv6WjwYELwukbv3M7wEgbtFIlOmm7PCu0v8lEuOhzQ1uj
uvW7RiU0RX00uSvUP5m0aiKMup+7vDy8vrFbwaE7xJQrv3MLQkG8v8irRkVswWMEYaSrwirHwjo8
wzDcPFp8QC00wM87RAfMxWBsRQE8uXf7v3UrxFE8QrkjxivMxhR8vlQMx5fLwVUMuXSMxJyrxN/7
xih8xWMsvoakRWqcwE8MSMwbw1IsulVkvwY8Q64Us0Izw16bye/rRHn8vJjMu6B8x5zc/8Uk/MFZ
jLpFrMmiXEeJW0WW3L+iVMBFCEqzbMpO+78qdEmXZMOobEn308Z27Mv0EzwEbLiTZLfInMytbMTG
rMxxm8vK28i+PM2adMmJtLXPTM3LnLxJFsKwLD5YHEbhPLNEq0xFO85A+83FbM7sjLPn7CixAs7l
HHj+67L2PE7qBLL6vM/83M/+/M/9LLIN9XOD12EEXdDxddAIvVwKvdCd1dAO/XIRPWtTJbLyBdET
zVYYndFXxdEG7dEXDdIJLdLMVdEfE9Ik7VkbndIoxdIP7dKFtdIwPVIyPdMJZdJohdI2vVY1vdMG
1dM+vVBB3dFDXWhFbdQBYNEjTdHcEv90JX3UPgXUUF12U21lVY1wV93SSX3SS01o5AeM4tdtUj3V
Yw3VZX3UZ13UaT3UOE1ZVObUHibWTfgvYU3RAgXXWU3VTgZfPs1nfL3Tfv3W/xZrFcZtgiZreO3V
dx1QhS3Ye51ZBddkGUZhkV3YkD1ljC3Z3HZQbZ1nb53YVk3Rc+0vda3YhJ3XPz3YJgXaHu3Xqx3U
gQ1ojw1r1zbbhk137+XYgabaBtdkul3bwA1wtz3cCtXZYGdtka3Rcg0wpV1luY3aBeXaJcXaHC3d
JEXdGR3bjx3c2Wbbwo3bmS3bs+3Yss3du41tms1kgwbZsUZSxh13yJ3cRO3Vo90vzf3/0ZkN3YY1
2Op92ZON2f7d29XN3+w92f+9YY2t2REd2AJu3uft3Q9Odsjl4LRN4Aj+3Q9O4f1dcJWN3fPlT0r9
3x5+08tN1yM+3xCu39p92662bSd+cCuO2MId3AA+4Ht9bTUecAke3zJe0K6t4zVe4Qde3t1t3hy+
25gdZR7+3kf22fId16LN3C+O1Lyt381l4QSnYS0+cE++4FgO5DN+2Rw+5WJt4Th+44td5egN3tvt
20Ku4Ny9bRke3kiubZud2lud06c9WGv9U/XNL/et0ykO3Qy+5jS+2V3u0IU+5y1+12Ru12i+3oKG
6Pmt2o/O5zye4xUe5FDG5UWO4egN/+Ci7t4gztXrjelRbuJlXulWfuWRzuiv5uIgveiHbuehPutf
Xttrbts9PuiQzuLdfd45LuNyXuvCfuECTuJ57tZqztMlTtqXjtWs3uof/upg7ukBzulebu1DvuPe
juuvHuHiLuYTJnDTTni8buAHfur+3eOW/e4dzunyTurL7tmCbtBAEO1aTe3R/ddo7e9qze94LvD7
Xe/H3dVVZjCrTvAC1dP6jtAOX9V93tcMX/AhztAV3/AZT3UbD1ATD9gd7+ohz+Sodu8Z//E2jfIz
rfIwzfIu7fIsTfI89/AIBfMpbfMkjfMirfPgPvIhr9cXr9I/X+0+//M839pDf/Q2vv+y9fIyAP30
UB/1Uj/1/7yyHeNNJJt4NqX1clayXN9sWQ949CxKYV/26vf1LYX22eX1Yu/WPWP26af2/cX2cI9+
ArOyTVP35yf360f3Z0/3eE/2MdXUFvf3em9+fO9aZR/44FxRX/2L4lf4ce/3k3/4jXf309b4MfXn
+xL5ju9sfFdpCnNza0dkBWZgteZosPVxs+UZ+kb6lAb6PLZiJLddCgdita9wro/7NJYwmD/2mh9R
7Gfikm9yoW9m+7Vv+nb6yq9ptN9urf9oyN/30g9xHIdrtm9u+VZnjfZQbe/Zb7/5Ui75DOd2op/8
imb6BwP7eTdj2L9u3L/8Ebf2akb/ZLafbsv2/tv/aLfF/on1/RBQ5KQSEFT15n1iJBRHsjTPkhBQ
A3VfOARHILZvPM9npO57H9AHIA5DxWNSt2SOeEaiCCk0CpXBZhb3TFZ/QWwN+yuJtecUyayU0txk
8houp6vh3zPIs7lk9n/AAh40GxUWQp3BO0TGRqe3qMW6STbHRi6gSryuuThLS8w1r6Eir6Opts8m
zLipsDeqzk4w2Uwq0sglvUALDN7fDUVVp5WTlmEUxTFk5i3I1NLZ29NmwlBoJFqxaNtqretN2kVJ
EznvF9bRu1c7ce02cfiyvBDgPmD8j3MRQ+N9/nn/BKaBJo8Tp2W5BjoreHATnoTL/xbCAGerlClN
CVNNfCSF2zuDGi+yoZRxnMQd9X7dy4dPGLN+Jo79U8ZxYcWSEEPaLPTMISWQKHmSwGnu4UaTsGzO
GJMzHMmm0n5KVcpkFy+WLX+9RBazxMx9NYeG9dkqysdTVYSOlVEW17ZIuK6wdVHx6N1pI6MOZWrH
SlowYc76RVU4l6sy3BKpxOpL61aBBAxMplwZ7DmudJtlRrFW8w3OJzx/jhGaNKjTNBkHyvoYkOnU
jGDHtrZkNG0Ts6viLs17s2+YqwG1dr1HN3BdyIcdV86wuSPmz3tLvyT8D/HiHaJTr8tdtndE28ET
HP+tPD0/jdNn9yD+fNv3q+LLn/+fvP7i+ynXD3fMvn1+/QDsScABCaTIwOkQ7G6/63wh4EEII5Rw
QgorFKRCDDPUcEMOO/TwQxBDFHFEEks08UQUU1RxRRZbdPFFGGOU0R5fmBFEQXRwXFDH3Hg8wb33
gDzvKtb6848DIctLcrwlwWvSuye5i5I6Ivlj8EgKppROy+e4bM5L5cBETkzgqmzwSiwlINO3NXlr
E7c3aYsztjlTM3MP7NJUMzINB6rztD9JC/SzQTUrlK47PchTzz9VEOBRSCG9zJtD2ap0rEv58rHH
TYmyDk8j9dSHpmJk8jMgHVnJ4TY5d7OBVTrLWocGtGjNxi+exPLIFHb+yugwYAP/E9ZW+mhEM81G
S/3q1F19VBUHWO10NYZoAYUknlkNQoocTXGlKtt4es1pXJKs+lTRUEW9kdRDIkMVx2dvqFbQaWGY
l9BrN6pDW01qybWdbXv1ZK5wqYpKI/OO5WBRZCNTloRJq9EV3meCBeyKuPqltyCLYzFrLjgrLhdb
oyQyaimAk6pEnYdAajnlekE7twOGsUy2XdW8VTAUjIDaKWRsTHonKDdFHtisjG3dy1JY3lq56VtB
fjncYS82V2E+0hX1Zn/c1RlBnC4e+qN7mZXa6bFdKdtrkEVpqCqTx+EonZGVEultcuEu1z5j1a2A
a1PZ3hZstwzGS6FY8Tb8ZMSl/8X7LYy4bZrpXZM+yu12ap06YMIGH7Bvv0cN6+ERIv7tawPDdtkM
ooE+e3Gp1ibrcXIQ5jzm2WvnF/PAYCZ39b3xAz30dUfHOXfPCQw7lloRkxtfxZl3fvqi376L8Wj0
Qt3svQwDltjuO/bVe2KvHj70Ri1T3+xO4Vt1vuhkt7Z9gOiH73y/M/3XfgTih9+2//FPfyjDmgZq
dqQBzo1//VtgAifiwJs0cGYL0xqjJCjAC9oPguxrX6JoVsGGYVCEGswg/TboNfyp64Q5I+EITVjC
Dk4wazKiYQ1teEMc5lCHO+RhD334QyAGcUP2GEARjXhEJCZRiUtkYhOd+EQoRv9RilOkYhWteEUs
ZlGLW+RiF734RTCGUYxjJGMZzQhFIp5RjWtkYxvd+EY4xlGOc6RjHe1IxzTeUY975GMf/fhHQAZS
kIM8Yx4JeUhEJlKRi2RkIx3pR0M+UpKTpGQlLXlJTOoxkpnkZCc9+UlQhlKSmxRlKU15SlSmUpVY
JOUqXflKWMZSlo5s5SxteUtc5lKXY6zlLn35S2AGc5e9FGYxjXlMZGaSmMlkZjOd+cw9LhOa06Rm
Na3ZRWleU5vb5GY3s9lNcIZTnMb85jjNeU50vrKc6WRnO92JSXuoT56UEcA87XlPfOZTnwYQQAEy
8E9/BhSgAxVoQQl6UIMmFKH/C1VoQxn6UIdGFKITlWhFKXpRi2YUoxvVaEc5+lGPhhSkIxVpSUl6
UpOmlKHxLEQ93bQClcYUpTOVaU1pelOb5hSnO9VpT3n6U58GFagoXUkLXuNS4mVHBUJl6lCb+lSn
RhWqU5VqVal6VatmtaEsPapRk+oaQ2BVrFol61jNWla0nlWtaWXrVItaQEEg9auPWWpb7bpWvN5V
r3nl61792teQcrUCANCACrw615aE9a+LBSxjHdtYyD5WspHN6FsHS9i/yRWx+agrZSf7Wc+GFrSj
FW1paSpYCxChsJrdLDAUa1rYkla2saXtbG3LV8umVrWZPWxrt9LP2wa3tsMVHm5xiXtckKK2AEVY
bW99G4jXGle6yKXudK1bXc9GAAA7
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0041.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Fuzzy
Matching is powerful, flexible
BUT
Every source record must be scored against =
EVERY target match, then highest scor=
es selected
100,000 records in target =3D> 100,000 scores <=
/span> per source record
Solution
is CLUSTERING
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0042.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Specify
• an
expression to sort target records into clusters
Then
• an
equivalent expression for source to sort it into one cluster
Finally
• sco=
ring
only done against members of the selected cluster
100,000
target divided into 20 clusters
• 5,0=
00
records per cluster =3D> 5,000 scores per source record
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0043.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Cluster expression should:
&=
#8226; Sort target into roughly equal groups
=
226; Guard against allocating source to wrong cluster
&=
#8226; Examples
&=
#8226; First letter of company name
&=
#8226; Zip/Post code
&=
#8226; Phone area code
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0044.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Alpha C=
orp
Zulu C=
orp
Beta C=
orp
Source record scored against every record in target <=
/div>
No
clustering established
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Set up
clustering based on first letter of compan=
y name
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Alpha =
Corp
Zulu Co=
rp
Beta C=
orp
Source record only scored =
against records in “b” cluster
Beta C=
orp
Brown Co=
rp
Cluster
on first letter
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Clustering =
Important Note
=
;
Because source re=
cords
will only be scored against
one cluster, if clustering is poorly done can lead to missed matches
• “naplex” wo=
uld
look in “n” cluster, not “I”
Cluster expression=
does
NOT have to use same fields as match
• E.g. Match on name, cluster on ZIP code
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/slide0048.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
Summary
Fuzzy matching provides powerful new tool for handling complex, dirty data
Need to
&=
#8226; Use carefully, especially clustering
&=
#8226; Allow of overhead of user review
Slide 1
©<=
span
style=3D'mso-spacerun:yes'> Copyright 2007 InaPlex Limited
THANK YOU
<=
/span>
<=
/span>
www.inaplex.com/cs/forums
numSlds )
gSldJumpIdx =3D numSlds;
if ( gSldJumpIdx >=3D 0 ) {
if ( gSldJumpIdx =3D=3D 0 )
gSldJumpIdx =3D 1;
var jumpTo =3D parseInt(gSldJumpIdx);
gSldJump =3D 0; gSldJumpIdx =3D "";
win.GoToSld( parent.GetSldList().mList[jumpTo-1].mSldHref )
}
}
}
function _KDH()
{
if( event.keyCode =3D=3D 8 ) {
event.returnValue =3D 0;
parent.GoToPrevSld();
}
}
function DocumentOnClick()
{
if( IsNts() || parent.HideMenu() ) return;
if( ( g_allowAdvOnClick && !parent.IsFramesMode() ) ||
(event && (event.keyCode=3D=3D32) ) )
parent.GoToNextSld();
}
var g_supportsPPTHTML =3D SupportsPPTHTML(), g_scaleInFrame =3D 1, gId=3D""=
, g_bgSound=3D"",
g_scaleHyperlinks =3D false, g_allowAdvOnClick =3D 1, g_showInBrowser =
=3D 0, gLoopCont =3D 0, gUseSldTimings =3D 1;
var g_showAnimation =3D g_supportsPPTHTML && SupportsPPTAnimation() && ( (w=
indow.name=3D=3D"PPTSld" && !parent.IsFramesMode()) || g_showInBrowser );va=
r g_animManager =3D null;
var g_animUseRuntime =3D false;
var g_animItemsToHide, g_animInteractiveItems, g_animSlideTime;
var g_animMainSequence =3D null;
var ENDSHOW_MESG=3D"End of slide show, click to exit.", SCREEN_MODE=3D"Fram=
es", gIsEndShow=3D0, NUM_VIS_SLDS=3D23, SCRIPT_HREF=3D"script.js", FULLSCR_=
HREF=3D"fullscreen.htm";
var gCurSld =3D gPrevSld =3D 1, g_offset =3D 0, gNtsOpen =3D gHasNts =3D gO=
tlTxtExp =3D 0, gHasNarration =3D 0, gOtlOpen =3D true
window.gPPTHTML=3DSupportsPPTHTML()
var g_fBaseHyperlink =3D false;
var gMainDoc=3Dnew Array(new hrefList("slide0001.htm",1,-1,1),new hrefList(=
"slide0007.htm",1,-1,1),new hrefList("slide0018.htm",1,-1,1),new hrefList("=
slide0009.htm",1,-1,1),new hrefList("slide0033.htm",1,-1,1),new hrefList("s=
lide0034.htm",1,-1,1),new hrefList("slide0050.htm",1,-1,1),new hrefList("sl=
ide0035.htm",1,-1,1),new hrefList("slide0016.htm",1,-1,1),new hrefList("sli=
de0017.htm",1,-1,1),new hrefList("slide0037.htm",1,-1,1),new hrefList("slid=
e0038.htm",1,-1,1),new hrefList("slide0039.htm",1,-1,1),new hrefList("slide=
0040.htm",1,-1,1),new hrefList("slide0041.htm",1,-1,1),new hrefList("slide0=
042.htm",1,-1,1),new hrefList("slide0043.htm",1,-1,1),new hrefList("slide00=
44.htm",1,-1,1),new hrefList("slide0046.htm",1,-1,1),new hrefList("slide004=
5.htm",1,-1,1),new hrefList("slide0047.htm",1,-1,1),new hrefList("slide0048=
.htm",1,-1,1),new hrefList("slide0049.htm",1,-1,1));
/*********************************************
Frameset functions
These functions control slide navigation
and state of the frameset.
**********************************************/
function RemoveFilePrefixFromHref(href)
{
var regExp =3D /^file:\/\/\//i;
return href.replace(regExp, "")
}
function FullScrInit()
{
g_allowAdvOnClick =3D GetCurSld().mAdvOnClk
document.body.style.backgroundColor=3D"black"
document.oncontextmenu=3Dparent._CM;
document.onkeydown =3D _KDH;
document.ondragstart=3DCancel
document.onselectstart=3DCancel
self.focus()
}
function Redirect( frmId )
{=09
var str=3Ddocument.location.hash,idx=3Dstr.indexOf('#'), sId=3DGetSldId()
if(idx>=3D0) str=3Dstr.substr(1);
if( window.name !=3D frmId && ( sId !=3D str) ) {
obj =3D GetObj("Main-File")
window.location.href=3Dobj.href+"#"+sId
return 1
}
return 0
}
var MHTMLPrefix =3D CalculateMHTMLPrefix();=20
function CalculateMHTMLPrefix()
{
if ( document.location.protocol =3D=3D 'mhtml:') {=20
href=3Dnew String(document.location.href)=20
Start=3Dhref.indexOf('!')+1=20
End=3Dhref.lastIndexOf('/')+1=20
if (End < Start)=20
return href.substring(0, Start)=20
else=20
return href.substring(0, End)=20
}
return '';
}
function GetTags(base,tag)
{
if(g_supportsPPTHTML) return base.all.tags(tag);
else return base.getElementsByTagName(tag);
}
function UpdNtsPane(){ if(frames["PPTNts"]) PPTNts.location.replace( MHTMLP=
refix+GetHrefObj( gCurSld ).mNtsHref ) }
function UpdNavPane( sldIndex ){ if(gNavLoaded) PPTNav.UpdNav() }
function UpdOtNavPane(){ if(gOtlNavLoaded) PPTOtlNav.UpdOtlNav() }
function UpdOtlPane(){ if(gOtlLoaded) PPTOtl.UpdOtl() }
function SetHasNts( fVal )
{
if( gHasNts !=3D fVal ) {
gHasNts=3DfVal
UpdNavPane()
}
}
function ToggleOtlText()
{
gOtlTxtExp=3D!gOtlTxtExp
UpdOtlPane()
}
function ClearMedia()
{
// Clear any sounds playing before launching another browser window. Other=
wise,
// in fullscreen mode, you'll continue to hear the sound in the frames mod=
e.
if (PPTSld.pptSound) PPTSld.pptSound.loop =3D 0;
}
function FullScreen()
{=20
if ( PPTSld.g_animUseRuntime )
PPTSld.document.body.pause();
ClearMedia();
var href =3D ( document.location.protocol =3D=3D 'mhtml:') ? FULLSCR_HREF =
: FULLSCR_HREF+"#"+GetHrefObj(gCurSld).mSldHref;
if (MHTMLPrefix !=3D "")
href =3D RemoveFilePrefixFromHref(href)
if(PPTNav.event.ctrlKey) {
var w =3D (window.screen.availWidth * 1.0) / 2.0
var h =3D w * (PPTSld.g_origH * 1.0) / PPTSld.g_origW
win =3D window.open( MHTMLPrefix+href,null,"toolbar=3D0,resizable=3D1,top=
=3D0,left=3D0," + "width=3D"+ w + ",height=3D" + h );
if( win.document.body && PPTSld.g_animUseRuntime )
win.document.body.PPTSldFrameset=3Dwindow;
}
else
{
win =3D window.open( MHTMLPrefix+href,null,"fullscreen=3Dyes" );
if( win.document.body && PPTSld.g_animUseRuntime )
win.document.body.PPTSldFrameset=3Dwindow;
}
}
function ToggleVNarration()
{
rObj=3DPPTSld.document.all("NSPlay")
if( rObj && !PPTSld.g_animUseRuntime ) {
if( (rObj.playState =3D=3D 1)||(rObj.playState =3D=3D 0) )
rObj.Play()
else if( rObj.playState =3D=3D 2 )
rObj.Pause()
else
return;
}
else if( PPTSld.g_animUseRuntime )
{
narObj =3D PPTSld.document.all("narrationID")
if( narObj )
narObj.togglePause()
}
}
function GetCurSldNum()
{ =20
obj=3DGetHrefObj(gCurSld)
if( obj.mOrigVis =3D=3D 1 )
return obj.mSldIdx
else =20
return gCurSld
}
function GetNumSlds()
{ =20
if( GetHrefObj(gCurSld).mOrigVis =3D=3D 1 )
return GetSldList().mNumVisSlds;
else
return GetSldList().mList.length
}
function GetSldNum( href )
{
for(ii=3D0; ii 1 )
PopSldList();
else if( !IsFramesMode() ) {
if( gLoopCont )
GoToFirst()
else
EndShow()
}
}
function GoToPrevSld()
{
ii=3DgCurSld-1
if( ii > 0 ) {
obj=3DGetHrefObj(ii)
while ( obj && ( obj.mVis =3D=3D 0 ) && ( ii>0 ) )
obj=3DGetHrefObj(--ii)
if( ii =3D=3D 0 ) ii=3D1
GoToSldNum(ii)
}
}
function GoToFirst(){ GoToSld( GetHrefObj(1).mSldHref ) }
function GoToLast()
{
ii=3DGetSldList().mList.length
if( ii !=3D gCurSld )
GoToSld( GetHrefObj(ii).mSldHref )
}
function GoToSldNum( num )
{
if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue
obj =3D GetHrefObj( num )
obj.mVis=3D1
gPrevSld=3DgCurSld
gCurSld =3D num;
=09
if (MHTMLPrefix !=3D "")
PPTSld.location.replace(MHTMLPrefix+RemoveFilePrefixFromHref(obj.mSldHref=
))
else
PPTSld.location.replace(obj.mSldHref)
=09
if( IsFramesMode() ) {
UpdNavPane(); UpdOtlPane(); UpdNtsPane()
}
}
function GoToSld( href )
{
if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue
GetHrefObj( GetSldNum(href) ).mVis=3D1
if (MHTMLPrefix !=3D "")
PPTSld.location.replace(MHTMLPrefix+RemoveFilePrefixFromHref(href))
else
PPTSld.location.replace(href)
}
function SldUpdated( id )
{
if( id =3D=3D GetHrefObj(gCurSld).mSldHref ) return
gPrevSld=3DgCurSld
gCurSld=3DGetSldNum(id)
if( IsFramesMode() ) {
UpdNavPane(); UpdOtlPane(); UpdNtsPane()
}
}
function PrevSldViewed(){ GoToSld( GetHrefObj(gPrevSld).mSldHref ) }
function HasPrevSld() { return ( gIsEndShow || ( gCurSld !=3D 1 && GetHrefO=
bj( gCurSld-1 ).mVis =3D=3D 1 )||( GetCurSldNum() > 1 ) ) }
function HasNextSld() { return (GetCurSldNum() !=3D GetNumSlds()) }
function CloseWindow() {
if( HideMenu() ) return;
=09
var event =3D PPTSld.event;
if( !IsFramesMode() && event && (event.keyCode=3D=3D27 || event.keyCode=3D=
=3D32 || event.type=3D=3D"click" ) )
window.close( self );
CatchNumKeys( self, event );
}
function Unload() { gIsEndShow=3D0; }
function SetupEndShow() {
gIsEndShow=3D1;
PPTSld.document.body.scroll=3D"no";
PPTSld.document.onkeypress=3DCloseWindow;
PPTSld.document.onclick=3DCloseWindow;
PPTSld.document.oncontextmenu=3D_CM;
}
function EndShow()
{
if( IsFramesMode() ) return
if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue
doc=3DPPTSld.document
var dir =3D doc.body.dir
if( dir !=3D "rtl" ) dir =3D "ltr";
doc.open()
doc.writeln('' + ENDSHOW_MESG + '
0) {
PushSldList(sldList,fEnd);
gCurSld =3D 1;
}
else
if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue
}
function PushSldList(arr,fEnd) {
var ii =3D gSldStack.length;
gSldStack[ii] =3D new SldList(arr,gCurSld,fEnd);
GoToSld( gSldStack[ii].mList[0].mSldHref );
}
function PopSldList() {
if (gSldStack[gSldStack.length-1].fEndShow)
EndShow()
else {
gCurSld =3D gSldStack[gSldStack.length-1].mCurSld;
gSldStack[gSldStack.length-1] =3D null;
gSldStack.length--;
var sldList =3D gSldStack[gSldStack.length-1];
GoToSld( sldList.mList[gCurSld - 1].mSldHref );
}
}
var custShowList=3Dnew Array();
/*********************************************
Navigation button implementation
There are 2 types of buttons: ImgBtn, TxtBtn
implemented as function objects. They share
a similiar interface so the event handlers
can call SetActive, for example, on a button=20
object without needing to know exactly=20
what type of button it is.
**********************************************/
//----------------------------------
function ImgBtn( oId,bId,w,action )
//----------------------------------
{
var t=3Dthis
t.Perform =3D _IBP
t.SetActive =3D _IBSetA
t.SetInactive=3D _IBSetI
t.SetPressed =3D _IBSetP
t.SetDisabled=3D _IBSetD
t.Enabled =3D _IBSetE
t.ChangeIcon =3D null
t.UserAction =3D action
t.ChgState =3D _IBUI
t.mObjId =3D oId
t.mBorderId=3D bId
t.mWidth =3D w
t.mIsOn =3D t.mCurState =3D 0
}
function _IBSetA()
{
if( this.mIsOn ) {
obj=3Dthis.ChgState( gHiliteClr,gShadowClr,2 )
obj.style.posTop=3D0
}
}
function _IBSetI()
{
if( this.mIsOn ) {
obj=3Dthis.ChgState( gFaceClr,gFaceClr,1 )
obj.style.posTop=3D0=20
}
}
function _IBSetP()
{
if( this.mIsOn ) {
obj=3Dthis.ChgState( gShadowClr,gHiliteClr,2 )
obj.style.posLeft+=3D1; obj.style.posTop+=3D1
}
}
function _IBSetD()
{ =20
obj=3Dthis.ChgState( gFaceClr,gFaceClr,0 )
obj.style.posTop=3D0=20
}
function _IBSetE( state )
{
var t=3Dthis
GetObj( t.mBorderId ).style.visibility=3D"visible"
if( state !=3D t.mIsOn ) {
t.mIsOn=3Dstate
if( state )
t.SetInactive()
else
t.SetDisabled()
}
}
function _IBP()
{
var t=3Dthis
if( t.mIsOn ) {
if( t.UserAction !=3D null )
t.UserAction()
if( t.ChangeIcon ) {
obj=3DGetObj(t.mObjId)
if( t.ChangeIcon() )
obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-4)*t.mWidth
else
obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-0)*t.mWidth
}
t.SetActive()
} =20
}
function _IBUI( clr1,clr2,nextState )
{
var t=3Dthis
SetBorder( GetObj( t.mBorderId ),clr1,clr2 )
obj=3DGetObj( t.mObjId )
obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-nextState)*t.mWidth-obj=
.style.posTop
t.mCurState=3DnextState
return obj
}
//-----------------------------------------
function TxtBtn( oId,oeId,action,chkState )
//-----------------------------------------
{
var t=3Dthis
t.Perform =3D _TBP
t.SetActive =3D _TBSetA
t.SetInactive=3D _TBSetI
t.SetPressed =3D _TBSetP
t.SetDisabled=3D _TBSetD
t.SetEnabled =3D _TBSetE
t.GetState =3D chkState
t.UserAction =3D action
t.ChgState =3D _TBUI
t.mObjId =3D oId
t.m_elementsId=3D oeId
t.mIsOn =3D 1
}
function _TBSetA()
{
var t=3Dthis
if( t.mIsOn && !t.GetState() )
t.ChgState( gHiliteClr,gShadowClr,0,0 )
}
function _TBSetI()
{
var t=3Dthis
if( t.mIsOn && !t.GetState() )
t.ChgState( gFaceClr,gFaceClr,0,0 )
}
function _TBSetP()
{
if( this.mIsOn )
this.ChgState( gShadowClr,gHiliteClr,1,1 )
}
function _TBSetD()
{ =20
this.ChgState( gFaceClr,gFaceClr,0,0 )
this.mIsOn =3D 0
}
function _TBSetE()
{
var t=3Dthis
if( !t.GetState() )
t.ChgState( gFaceClr,gFaceClr,0,0 )
else
t.ChgState( gShadowClr,gHiliteClr,1,1 )
t.mIsOn =3D 1
}
function _TBP()
{
var t=3Dthis
if( t.mIsOn ) {=20
if( t.UserAction !=3D null )
t.UserAction()
if( !t.GetState )
return
if( t.GetState() )
t.SetPressed()
else
t.SetActive()
} =20
}
function _TBUI( clr1,clr2,lOffset,tOffset )
{
SetBorder( GetObj( this.mObjId ),clr1,clr2 )
Offset( GetObj( this.m_elementsId ),lOffset,tOffset )
}
function Offset( obj, top, left ){ obj.style.top=3Dtop; obj.style.left=3Dle=
ft }
function SetBorder( obj, upperLeft, lowerRight )
{
s=3Dobj.style;
s.borderStyle =3D "solid"
s.borderWidth =3D 1=20
s.borderLeftColor =3D s.borderTopColor =3D upperLeft
s.borderBottomColor=3D s.borderRightColor =3D lowerRight
}
function GetBtnObj(){ return gBtnArr[window.event.srcElement.id] }
function BtnOnOver(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetActive() }
function BtnOnDown(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetPressed() }
function BtnOnOut(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetInactive() }
function BtnOnUp()
{
b=3DGetBtnObj()
if( b !=3D null )
b.Perform()
else
Upd()
}
function GetNtsState(){ return parent.gNtsOpen }
function GetOtlState(){ return parent.gOtlOpen }
function GetOtlTxtState(){ return parent.gOtlTxtExp }
function NtsBtnSetFlag( fVal )
{
s=3Ddocument.all.item( this.m_flagId ).style
s.display=3D"none"
if( fVal )
s.display=3D""
else
s.display=3D"none"
}
function _BSetA_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S=
etActive() }
function _BSetI_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S=
etInactive() }
function _BSetP_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S=
etPressed() }
function _BSetA_BorderImg()
{=20
b =3D gBtnArr[this.mBorderId]=20
if( b !=3D null && this.mIsOn && !b.GetState() ) {
obj=3Dthis.ChgState( gHiliteClr,gShadowClr,2 )
obj.style.posTop=3D0
}
}
function _BSetI_BorderImg()
{=20
b =3D gBtnArr[this.mBorderId]
if( b !=3D null && this.mIsOn && !b.GetState() ) {
obj=3Dthis.ChgState( gFaceClr,gFaceClr,1 )
obj.style.posTop=3D0
}
}
var gHiliteClr=3D"THREEDHIGHLIGHT",gShadowClr=3D"THREEDSHADOW",gFaceClr=3D"=
THREEDFACE"
var gBtnArr =3D new Array()
gBtnArr["nb_otl"] =3D new TxtBtn( "nb_otl","nb_otlElem",parent.ToggleOtlPan=
e,GetOtlState )
gBtnArr["nb_otlElem"] =3D new TxtBtn( "nb_otl","nb_otlElem",parent.ToggleOt=
lPane,GetOtlState )
gBtnArr["nb_nts"] =3D new ImgBtn( "nb_nts","nb_ntsBorder",10,parent.ToggleN=
tsPane )
gBtnArr["nb_nts"].SetActive =3D _BSetA_BorderImg;
gBtnArr["nb_nts"].SetInactive =3D _BSetI_BorderImg;
gBtnArr["nb_ntsBorder"] =3D new TxtBtn( "nb_ntsBorder","nb_ntsElem",parent.=
ToggleNtsPane,GetNtsState )
gBtnArr["nb_ntsElem"] =3D new TxtBtn( "nb_ntsBorder","nb_ntsElem",parent.To=
ggleNtsPane,GetNtsState )
gBtnArr["nb_prevBorder"] =3D gBtnArr["nb_prev"]=3D new ImgBtn( "nb_prev","n=
b_prevBorder",30,parent.GoToPrevSld )
gBtnArr["nb_nextBorder"] =3D gBtnArr["nb_next"]=3D new ImgBtn( "nb_next","n=
b_nextBorder",30,parent.GoToNextSld )
gBtnArr["nb_sldshw"]=3D new ImgBtn( "nb_sldshw","nb_sldshwBorder",18,parent=
.FullScreen )
gBtnArr["nb_sldshwBorder"] =3D new TxtBtn( "nb_sldshw","nb_sldshwBorder",pa=
rent.FullScreen,null )
gBtnArr["nb_sldshwBorder"].SetActive =3D _BSetA_Border;
gBtnArr["nb_sldshwBorder"].SetInactive =3D _BSetI_Border;
gBtnArr["nb_sldshwText"] =3D new TxtBtn( "nb_sldshw","nb_sldshwText",parent=
.FullScreen,null )
gBtnArr["nb_sldshwText"].SetActive =3D _BSetA_Border;
gBtnArr["nb_sldshwText"].SetInactive =3D _BSetI_Border;
gBtnArr["nb_voice"] =3D gBtnArr["nb_voiceBorder"] =3D new ImgBtn( "nb_voice=
","nb_voiceBorder",18,parent.ToggleVNarration )
gBtnArr["nb_otlTxtBorder"] =3D gBtnArr["nb_otlTxt"]=3D new ImgBtn( "nb_otlT=
xt","nb_otlTxtBorder",23,parent.ToggleOtlText )
gBtnArr["nb_ntsBorder"].m_flagId=3D "nb_nts"
gBtnArr["nb_ntsBorder"].SetFlag =3D NtsBtnSetFlag
gBtnArr["nb_otlTxt"].ChangeIcon=3D GetOtlTxtState
/*********************************************
Context menu implementation
_CM() is the function that's hooked up to
the oncontextmenu event. Once we're asked to
show the menu, we first build it by creating
DIVs on-the-fly. Then we position it=20
within the screen area so it doesn't get
clipped.
Creating the DIVs using createElement() means
we don't have to write out any extra HTML
into the slide HTML files.
**********************************************/
var sNext=3D"Next",sPrev=3D"Previous",sEnd=3D"End Show",sFont=3D"Arial",sAr=
row=3D"Arrow",sFreeform=3D"Freeform",sRect=3D"Rectangle",sOval=3D"Oval"
function ShowMenu()
{
BuildMenu();
var doc=3DPPTSld.document.body,x=3DPPTSld.event.clientX+doc.scrollLeft,y=
=3DPPTSld.event.clientY+doc.scrollTop
m =3D PPTSld.document.all.item("ctxtmenu")
m.style.pixelLeft=3Dx
if( (x+m.scrollWidth > doc.clientWidth)&&(x-m.scrollWidth > 0) )
m.style.pixelLeft=3Dx-m.scrollWidth
m.style.pixelTop=3Dy
if( (y+m.scrollHeight > doc.clientHeight)&&(y-m.scrollHeight > 0) )
m.style.pixelTop=3Dy-m.scrollHeight
m.style.display=3D""
}
function _CM()
{
if( !parent.IsFullScrMode() ) return;
if(!PPTSld.event.ctrlKey) {
ShowMenu()
return false
} else
HideMenu()
}
function BuildMenu()
{
if( PPTSld.document.all.item("ctxtmenu") ) return
var mObj=3DCreateItem( PPTSld.document.body )
mObj.id=3D"ctxtmenu"
mObj.style.visibility=3D"hidden"
var s=3DmObj.style
s.position=3D"absolute"
s.cursor=3D"default"
s.width=3D"120px"
SetCMBorder(mObj,"menu","black")
var iObj=3DCreateItem( mObj )
SetCMBorder( iObj, "threedhighlight","threedshadow" )
iObj.style.padding=3D2
CreateMenuItem( iObj,sNext,M_GoNextSld,M_True )
CreateMenuItem( iObj,sPrev,M_GoPrevSld,M_HasPrevSld )
=09
CreateSeparator( iObj )
CreateMenuItem( iObj,sEnd,M_End,M_True )
mObj.style.visibility=3D"visible"
}
function Cancel() { window.event.cancelBubble=3Dtrue; window.event.returnVa=
lue=3Dfalse }
function Highlight() { ChangeClr("activecaption","threedhighlight") }
function Deselect() { ChangeClr("threedface","menutext") }
function Perform()
{
e=3DPPTSld.event.srcElement
if( e.type=3D=3D"menuitem" && e.IsActive() )
e.Action()
else
PPTSld.event.cancelBubble=3Dtrue
}
function ChangeClr( bg,clr )
{
e=3DPPTSld.event.srcElement
if( e.type=3D=3D"menuitem" && e.IsActive() ) {
e.style.backgroundColor=3Dbg
e.style.color=3Dclr
}
}
function M_HasPrevSld() { return( parent.HasPrevSld() ) }
function M_GoNextSld() { if( gIsEndShow ) M_End(); else GoToNextSld() }
function M_GoPrevSld() { if( gIsEndShow ) { gIsEndShow=3D0; history.back();=
PPTSld.event.cancelBubble=3Dtrue; } else GoToPrevSld() }
function M_True() { return true }
function M_End() { window.close( self ) }
function CreateMenuItem( node,text,action,eval )
{
var e=3DCreateItem( node )
e.type=3D"menuitem"
e.Action=3Daction
e.IsActive=3Deval
e.innerHTML=3Dtext
if( !e.IsActive() )
e.style.color=3D"threedshadow"
e.onclick=3DPerform
e.onmouseover=3DHighlight
e.onmouseout=3DDeselect
s=3De.style;
s.fontFamily=3DsFont
s.fontSize=3D"9pt"
s.paddingLeft=3D2
}
function CreateSeparator( node )
{
var sObj=3DCreateItem( node )
SetCMBorder(sObj,"menu","menu")
var s=3DsObj.style
s.borderTopColor=3D"threedshadow"
s.borderBottomColor=3D"threedhighlight"
s.height=3D1
s.fontSize=3D"0px"
}
function CreateItem( node )
{
var elem=3DPPTSld.document.createElement("DIV")
node.insertBefore( elem )
return elem
}
function SetCMBorder( o,ltClr,rbClr )
{
var s=3Do.style
s.backgroundColor=3D"menu"
s.borderStyle=3D"solid"
s.borderWidth=3D1
s.borderColor=3DltClr+" "+rbClr+" "+rbClr+" "+ltClr
}
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/fullscreen.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/buttons.gif
Content-Transfer-Encoding: base64
Content-Type: image/gif
R0lGODlhWAESAPf4AAAAAIAAAACAAICAAAAAgIAAgACAgICAgAQEBISEBASEBISEhAQEhMTExAQE
/KTM9Pz8/ERERPz8BAT8/KSkpGRkhMTcxCRkxAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAMDAwP8AAAD/AP//AAAA//8A/wD//////yH5BAEAAPgALAAAAABYARIA
QAj/APEJHEiwoMGDCBMqXMiwocOHECNKnEixosWLGCEiQKCRo8YDIEHig2DxAD4LKD1avDDhgUuV
GUOGbHBR5QGYFBG4fHAB58EKECJEwCfUYAWPFGAygLCRKQIIUKM6WAohKUGgCikcFWh1INWoYKVS
7SrQ41GbIhGYLAuVQVOoC+IyXUuUAkG1HE3KFDhAwkgJc5/qDZmxsOHDiBMrXsy4sePDGyP7lChT
5MULmDPnlDw5YmW6FTNrfgi0aNGEZPEtbfo2bNTUpYeeRph69dPWrqvCNFuBIGG1A59CYPAVQtwF
cw0OxWdTIOiBCQAjaAB17fOFII8voGmRc+eOkilm/z9OvTtnjN4hYk1YoT3H2rnBOphPAB9skgq3
2lcaX/5YnJVt9BloAar12UEIRGCZdQghMABI1Tn32IQUVthYexhmqGGGMBHAgIfEhSiiiATAtOGJ
GnYI4ogsEldicAYOGNJGZaml3Y0L3NTZUBz1xlB0PUoUI0jlVWRSVN89xBKSGB1YU1TMoRfVBEle
hR9HQs1GEHxQ3RZZbveZthxt/LEmXHyp5XWABSCpaRJwbM13gAACPHVccgJFgF+NEhqUAEkQSCfc
ddhVhh5dVTaEAEsTUNlkZUWKN9BNGDE6QU8OrSdbllzpxyVTTrU21Uj3scfhp7nNpyoDaTIEJ3P9
If8J2kbLNYegg9JRBwGhFvbq66+ZUiDssMQWK2yHxiZLrInKNotss8l+B5yBrr5p2UIJvortANoC
6+234IbLla/elRtZjeamh5CC3Sb0YLvixivvYkDFGlZqBNh7r4n6goVvv6/ZlCicN+kL71ALTnpQ
dCIZp7CihkLA3UQmoWRBogyxtBPGCTnZncVR1rSTo5nuydC/Eo8kUH+lOoTyyvjoCuZu+PjYIKLD
rZybtrM1d10C0QXKEVz48GrQkEeWdFJKlbb0UmEeV0SzyC6RvNB646LWIVjUNeC1zAFb+RDKXksM
9r531bwmpQW9+hQDDsx5pqwDRWBXcFES2hc+gEn/wJGdEEWdE6LoWcoxQweaTNmkhydkKaYMYY2Q
p1unbLl/pPKbn3v7EZRvrKvqlja2ONvrtoIw9tn2g32/tQBlhtYkU+MNikZ7QYlPDPuMldpOmuJX
nVo5VF3HjI+q89mteX5IDd/fVFClma5kiE4f2XUJhlz09gj2NbTDRifkmu7zXjR++RVJ/lPznuvr
QH2iD6S+UewP9Dnon6d2NLwN8n90BB6hC68cFMCHoe+ACASP9c4DowUyEF0OPFcDI0ij/VXPaAKC
UfhS95AKGoQ7IBRICI1HwhGaUIQoLGEKT6jCFrLwhSuMoQtlCMMZ2rCGOKShDm+4wxzy8Ic+DGIP
B4cIRCKGMCAAOy==
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/frame.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
Slide 1
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/outline.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"
No=
tes
1
2
Matching
Process of deciding which record or set of records in the target
table(s) should be updated
Alternatively, decide if record already exists and take appropriate
action
3
Inaport supports different ways to match
Standard
build expressions on source and target
Fuzzy
Refine Standard to allow for poor data
SQL
Use SQL SELECT instead of expressions
External
Use an external match file generated by another application such as
Paribus
4
Standard Matching
can use any combination of fields
can use expressions
BUT
Ultimately is restricted to exact match
“InaPlex”
<>
“Innerplex Ltd”
5
Fuzzy matching compares source and target, and gives a similarity sc=
ore
Score measures how “close” two strings are
6
As with Standard matching, Fuzzy match
Can use any field or combination of fields
Reads the match fields
Builds an in memory index for each table
The target match expression is applied to the field data read from=
the
table
7
Set scoring levels
Score > Upper
good match – accept immediately
Lower < Score < Upper
Possible match – user review
Score < lower
No match <
Lower < Possible < Upper < Good
No match < 85% < Possible < 95% < Good
8
When a source record comes in:
Source expression applied to build match value
Source match value scored against every value in target index
“Best” matches used – you set boundaries
No match < Possible match < Good match
No &nb=
sp;
0.85
Possible =
0.95
Good
9
User Review
Shows the source record and possible matches in target
User can select one or more records as match
Options
Review “good” and “possible” matches
Review just “possible” matches
If there are no possibles, good and no match accepted automatical=
ly
No review
Good and no match accepted automatically
Possible treated as bad
10
Customise User Review
May need to see more than the target table to decide on match
Can also display associated tables
Can also select which fields from associated tables to display
11
Select Fuzzy Match from Match Type
12
Specify the base match criteria
13
14
Shows possible matches at run time
15
Fuzzy Matching is powerful, flexible
BUT
Every source record must be scored against EVERY target match, then
highest scores selected
100,000 records in target =3D> 100,000 scores per source record
Solution is CLUSTERING
16
Specify
an expression to sort target records into clusters
Then
an equivalent expression for source to sort it into one cluster
Finally
scoring only done against members of the selected cluster
100,000 target divided into 20 clusters
5,000 records per cluster =3D> 5,000 scores per source record
17
Cluster expression should:
Sort target into roughly equal groups
Guard against allocating source to wrong cluster
Examples
First letter of company name
Zip/Post code
Phone area code
18
19
Set up clustering based on first letter of company name
20
21
Important Note
Because source records will only be scored against one cluster, if
clustering is poorly done can lead to missed matches
“naplex” =
would
look in “n” cluster, not “I”
Cluster expression does NOT have to use same fields as match
E.g. Match on name, cluster on ZIP code
22
Fuzzy matching provides powerful new tool for handling complex, dirty
data
Need to
Use carefully, especially clustering
Allow of overhead of user review
23
THANK YOU
www.inaplex.com
www.inaplex.com/cs/forums
------=_NextPart_01C8993F.C84F2AC0
Content-Location: file:///C:/C29C77B9/Match_Fuzzy_files/filelist.xml
Content-Transfer-Encoding: quoted-printable
Content-Type: text/xml; charset="utf-8"
------=_NextPart_01C8993F.C84F2AC0--
![](3D"master05_background.gif")
![](3D"master05_image003.gif")
![](3D"master04_background.gif")
![](3D"master04_image004.gif")
![](3D"slide0033_image005.gif")
![](3D"slide0037_image006.gif")
![](3D"slide0038_image007.gif")
![](3D"slide0039_image008.gif")
![](3D"slide0040_image009.gif")
![](3D"slide0044_image010.gif")
![](3D"slide0044_image011.gif")
![](3D"slide0044_image012.gif")
![](3D"slide0044_image013.gif")
![](3D"slide0046_image014.gif")
![](3D"slide0045_image015.gif")
![](3D"slide0045_image016.gif")
![](3D"slide0045_image017.gif")
![](3D"slide0045_image018.gif")
![](3D"slide0045_image019.gif")
![](3D"slide0045_image020.gif")
![](3D"notes_flag.gif")
No=
tes![](3D"buttons.gif")
