Build History:SSIS:Data Quality Components

From Melissa Data Wiki
Revision as of 22:40, 24 July 2013 by Admin (talk | contribs)
Jump to navigation Jump to search

Build 09/2012

Released September 2012

Intersecting deduper
Re-Worked Intersecting Deduper for improved performance
New Match Code Editor Interface
Simplified and improved the MatchCode Editor
Added Fuzzy Matching Algorithms
The following algorithms were added for fuzzy matching compatibility:
  • N-Gram
  • Jaro
  • Jaro-Winkler
  • Longest Common Substring
  • Needleman-Wunsch
  • MD Keyboard
  • Smith-Waterman-Gotoh
  • Dice’s Coefficient
  • Jaccard Similarity
  • Overlap Coefficient
  • Double Metaphone
Added new Match Code Types
The following match code types were added to MatchUp:
  • Proximity
  • Numeric
  • Date
2012 Compatibility
The Data Quality Components for SSIS is now available and supported in SQL Server 2012
New Global Component
Global Component for validating and correcting international addresses is now released for SQL Server 2005, 2008 and 2012.
Notice
2005 SSIS Components have been deprecated and are no longer fully supported.


Build 06/2012

Released June 2012

Compatibility Summary
Address: None. Object and Data file only update.
Name: None
Phone: None
Email: None
Installer
If the installer cannot recognize (or mis-recognizes) the version of SQL Server SSIS that you have installed, you can force it to install to a particular version with one of the command-line switches: /Force2005x32, /Force2005x64, /Force2008x32 or /Force2008x64. Only use one of these switches at one time. Often, the installer has recognition issues because a critical component of SQL Server may be missing (such as SSIS services). As a result, after forcing an install in this manner, you may have difficulties using the DQS components.
Contact Verification Component
Version: 1.0.1.9
Address Object Build: 1974
Name Object Build: 1974
Phone Object Build: 1974
Email Object Build: 1974
Geocoder Object Build: 1979
Database Date: 5/15/2012
Changes
  • Added 'Report result codes for empty input' option to 'Output Filter' tab.
  • User may now specify a proxy server on 'Advanced' dialog.
  • Fixed bug: sometimes the Canadian Geocoding option wasn't getting recognized.
SmartMover Component
Version: 1.0.1.6
Changes
  • User may now specify a proxy server on 'Advanced' dialog.
Fuzzy Matching Component
Version 2.0.0.10
Changes
  • Minor name change.
MatchUp Component
Version 2.0.0.6
MatchUp Object Build: 1985
Changes
  • Matchcode Editor is now fully integrated into component.
  • Fixed bug, combination result codes not reported in all setup configurations.
  • Fixed crash/hang in certain setup configurations involving passthrough fields.
  • User may now specify where work files are stored in 'Advanced Configuration dialog.
  • New matching data types: Geographic Proximity, Numeric Difference, Date Difference.
  • New fuzzy matching rules: N-Gram, Jaro Distance, Jaro-Winkler Distance, Longest Common Substring, Jaccard Index, Dice's Coefficient, Overlap Coefficient, Needleman-Wunsch, Smith-Waterman-Gotoh, MD Keyboard, Double Metaphone.
  • Improved matching accuracy in some situations.
  • Improved matching speed in some situations.
  • Eliminated certain matchcode requirements and restrictions that were previously required.
  • Added 'Record Suppresion' processing mode.
  • Added 'Record Intersection' processing mode.