Build History:SSIS:Data Quality Components: Difference between revisions

Revision as of 18:22, 31 January 2013

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:

Added new Match Code Types

The following match code types were added to MatchUp:

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.

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

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.

@@ Line 1: / Line 1: @@
 {{CustomTOC}}
-==Current Build==
+==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''