Spectrum Advanced Matching - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
How Do I
Overview
Tips
Reference
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

Spectrum Advanced Matching matches records between and within any number of input files. You can also use Spectrum Advanced Matching to match on a variety of fields including name, address, name and address, or non-name and address fields, such as social security number or date of birth.

Components

Spectrum Advanced Matching is implemented by the following stages in Enterprise Designer:

  • Best-of-Breed—This stage selects a best-of-breed record from the duplicates cluster by selecting a template record, then using that record to build a composite record that becomes the survivor record.
  • Candidate Finder—This stage finds candidate records that will form the set of potential matches that the Transactional Match stage will evaluate. Candidate Finder is used with Transactional Match.
  • Duplicate Synchronization—This stage allows you to specify fields from a collection of records to copy (post) to the corresponding fields of all records in the collection.
  • Filter—This stage allows you to specify the criteria that records must satisfy to be retained or removed from a collection of duplicate records, either for further processing downstream or for your output file.
  • Group Key Generator—This stage uses a group strategy to create group keys and transitively merge selected fields.
  • Interflow Match—This stage identifies matches between similar data records across multiple input streams.
  • Intraflow Match—This stage identifies matches between similar data records within a single input stream.
  • Match Key Generator—This stage creates a non-unique key shared by all like records. You have the option of grouping records that share the same key for comparison.
  • Transactional Match—This stage matches suspect transactions against a database using the Candidate Finder Stage to query and return potential candidate records.
  • Write to Search Index—This stage enables you to create a full-text index based on the data that the stage is accepting for processing. You can retain data in a dedicated search index to improve response times when searching the Candidate Finder.