Business and Technical Metadata along with some data profiling, in a metadata mart, provide a roadmap for navigating through your data files , giving you the most direct route and path to data quality issues, much like the legend on that map. And if you have maintained a linkage between the Business , Technical and Metadata Mart you will have a quick and safe journey.
Unfortunately I will not be able to attend SQL Saturday 96. I apologize to anyone who planned to attend the session, please see links below or contact me at iwhiteside@iwhiteside.com and I will schedule a GOTO Meeting.
Record Linkage Fuzzy Match (SSIS, TSQL, and MDS)
Speaker: Ira Whiteside
LiveMeeting Session Recording:
mms://passmedia.sqlpass.org/share/bi/PASSDWBIVC_09282011_livemeeting.wmv
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) – T-SQL
http://www.sqlservercentral.com/articles/Fuzzy+Match/65702/
Record Linkage and Fuzzy Matching Part 2
http://blog.melissadata.com/data-quality-authority/2010/10/record-linkage-and-fuzzy-matching-part-2.htm
Ira Warren Whiteside's Blog - Information Sherpa 