Objects H

Description

Click to specify columns to be analyzed for duplicate records.

Click to view duplicate results for the object.

Click to open the Bulk Duplicate Detection page in System Administration to view details about the search tables used in duplicate detection.

NOTE: A user must have access to System Administration to access this page.

Displays name of object being analyzed for duplicate records.

Click to find duplicate records.

Displays number of records returned by the duplicate detection process.

Displays count of potential duplicate records in the data source.

Displays count of duplicate candidates that are not yet resolved. Click to resolve duplicate candidates.

Displays count of resolved duplicates in the data source.

Displays percent of total duplicate candidates that have been resolved.

Description

Click to open the Dictionaries page in System Administration to add, edit and delete dictionary entries. Users must have access to System Administration to manage dictionaries.

Click to open the Stop Lists page in System Administration to add, edit and delete stop list entries. Users must have access to System Administration to manage stop lists.

Click to open the Bulk Duplicate Detection page in System Administration to run the bulk duplicate detection administration process for the object.

NOTE: Users must have access to System Administration to run duplicate detection.

Object Settings

Displays name of object being analyzed for duplicate records.

Displays name of object. Click to view details about the object.

Click to open the Objects page to view object’s data.

Advanced Settings

Displays ID of the search table that controls which record pairs in the source data are stored as a duplicate. The Stewardship Tier is delivered with a default search table, DSPCommon.ttDuplcate, that has been set up for the BDD process.

NOTE: If a search table other than DSPCommon.ttDuplicate is to be used, it must be set up in System Administration.

Displays characters excluded from the duplicate detection search.

Displays ID for list of words ignored during the duplicate detection search. Default value is managed in Configuration > Modules > Parameters-Duplicates.

Displays level to ignore false positives.

Displays weight percent of the calculated value for matched words. Words that match carry more weight than words that sound alike. Default value is managed in Configuration > Modules > Parameters-Duplicates.

Displays weight value of synonym matches.

Displays percentage of combined calculated value for words found within the search (number of words found plus the number of words that sound alike divided by the total number of words). Words that match carry more weight than words that sound alike.

Displays ID for custom SQL Server Sound Ex function. Selecting a custom function improves accuracy of duplicate detection, but consequently, decreases performance.

Displays number of records to process in one pass through the data. Default valus is 1000.

Displays number of records queued up in the duplicate detection process. This field allows a subset of large files to be processed and at the same time, limits the resources required.

Displays number of words in each duplicate pair. A value less than 50% marks a duplicate value for removal. For example, if A has 10 words and B has 1 word, which matches on one of A’s words, then A-B matches 10%, but B-A matches 100%. This 100% is the false positive; the Word Ratio will remove this as a potential match. Default value is managed in Configuration > Modules > Parameters-Duplicates.

Click to remove blank lines from the HTML formatted output in the Candidates page. This action makes each object block smaller because white space is removed. When comparing objects with multiple lines, such as address data, multiple lines may cause the data to not line up on the page. If needed, the Remove Blank Lines check box can be disabled and the object can be re-built. Default value is managed in Configuration > Modules > Parameters-Duplicates.

If enabled, Unicode characters (double-byte) are included in the duplicate detection process.

Description

Click to find duplicates.

Click to open the Object History page to view details on previous builds (i.e., duplicate searches) for the object.

Click to change the status of the build from Processing to Procedures Completed. Only reset status if the build process is aborted and the status is still processing

Click to remove all previous duplicates and non-duplicate results for the object. Button is only available for objects that returned duplicates (which display on the Results page). This action is not reversible; it is recommended to back up the drResultsDuplicate table before the results are reset.

Click to continue running a stopped process.

Description

Displays current status of the duplicate detection build process.

Displays number of records to be processed.

Displays actual number of records processed at this point in time; value changes during processing.

Displays number of records that still need to be processed.

Displays number of records marked as duplicates.

Displays time to run the duplicate detection process.