Melissa - Global Intelligence  1-800-MELISSA

What’s new in Data Quality Components for SSIS 4.1


What’s new:


MatchUp Survivorship Capabilities

Melissa Data Introduces a new and powerful functionality for the MatchUP Component. Survivorship allows you to consolidate data while specifying rule based expressions for prioritizing which data to keep.


For example, consider the following matching records:



Using the Golden Record selection by latest update, the selected remaining record would be:



But if we set survivorship for longest name and greatest amount, we can populate our remaining record with values from other matching records.



The survivorship option can be setup in the Survivorship/Passthrough Tab.



Double clicking on Prioritization will allow you to specify prioritization rules as well as specifying the source of the data which will populate the output column.



Change History:


ECCMA Associate Member, NACUM logo, DMA Member, Alliance of Nonprofit Mailers, EPICOMM, Deutschen Dialogmarketing Verband - DDV logo, AICPA SOC certified