Numerous techniques and solutions enable common forms of data cleansing, yet the same routines become tedious and complicated in the Microsoft ® SSIS (SQL Server ® Integration Services) platform. Operations such as proper casing, abbreviations, search and replace patterns, and expressions typically require multiple components as well as some form of coding through script components. SSIS developers find this issue is emphasized when dealing with data types that require several cleansing rules specific to that domain or where data quality solutions are not readily available.
Melissa Data, a leading provider of contact data quality and address management solutions, will demonstrate in a free webinar how SSIS users can simplify and centralize data quality using techniques that can be universally applied to any type of data. The session is presented in partnership with MSSQLTips.com, focused on educating and solving real-world problems for the global SQL Server community.
The webinar will be led by Melissa Data’s Joseph Vertido, data quality analyst, author and strategist. Vertido is noted for his capabilities in analyzing enterprise architecture and business environments, determining ideal methods for integrating data quality into existing business infrastructures.
WHY: Join this webinar to gain insight on different techniques in generalized data cleansing and how they can be easily implemented in SSIS, including:
• Proper Casing
• Punctuation Handling
• Search and Replace Tables
WHEN: Wednesday, December 7, 2016 from 3:00 PM to 4:00 PM EST