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 firstname.lastname@example.org and I will schedule a GOTO Meeting.
Record Linkage Fuzzy Match (SSIS, TSQL, and MDS)
Speaker: Ira Whiteside
LiveMeeting Session Recording:
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) – T-SQL
Record Linkage and Fuzzy Matching Part 2