SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Match Statistics - Status UNMATCH  XML
Forum Index » SQL Power DQguru Bugs
Author Message
lilihammer


Joined: 2007-06-07 14:18:48
Messages: 101
Offline

Currently, if a user was to automatch a specific munge process, in the match validation screen it shows a specific number of rows now marked as matched, and then it also shows the remainder as UNMATCH.
The user would assume that the match validation screen should mark the remainder as NO-MATCH.
Jonathan
SQL Power Developer

Joined: 2007-01-08 15:10:32
Messages: 873
Offline

The user who assumes that is not clear on the meanings of those statuses.

MATCH: The pair of records definitely represents the same thing. One is the master and the other is the duplicate.

UNMATCH: The pair of records has similar field values, but has not been flagged as having a master/duplicate relationship

NOMATCH: The pair of records has similar field values, but the two records have been confirmed not to represent the same thing.

When you auto-match, a master record is randomly chosen within each "cluster" of matches, then all other records in that cluster are considered duplicate. The presence of any NOMATCH records in the cluster would be a contradiction, since the same pair of records would simultaneously represent the same thing and be definitely not the same thing. This is impossible unless you are Schrödinger's cat.

-Jonathan
 
Forum Index » SQL Power DQguru Bugs
Go to:   
Powered by JForum 2.1.8 © JForum Team