Session Teaches SQL Server Developers How to Reveal and Correct Data Formatting Issues, Better Detect Duplicates and Easily Apply Validation Processes
Rancho Santa Margarita, CALIF– May 19, 2015 – Melissa, a leading provider of contact data quality and address management solutions, today announced a new webinar presented in partnership with MSSQLTips.com, a group of SQL Server experts sharing education and problem-solving insight with the global SQL Server community. Titled “How to Roll Your Own Value, RegEx and SoundEx Pattern Profiler in SSIS,” the webinar will focus on data profiling as the foundation for successful implementation of a comprehensive data quality regimen. Attendees will learn how to simplify Value, Regular Expression (RegEx) and Sound Expression (SoundEx) patterns in development scenarios based on SQL Server Integration Services (SSIS). The webinar takes place from noon to 1:00 pm Pacific on Tuesday, June 2, 2015; click here for free registration.
“Data profiling includes recognition of patterns in the data, a process which plays an essential role in validating correct information,” said Joseph Vertido, Data Quality Analyst, Melissa. “Building this functionality can be daunting for developers, and we will illustrate ways to reduce complexity and accelerate the development process.”
In this webinar, attendees will learn how to leverage Value and RegEx pattern profiling to expose formatting problems within different data types, improve detection of duplicates through SoundEx patterns and how to apply them in data validation procedures. Attendees will also gain insight on how to roll their own Value, RegEx and SoundEx Script Component for generating pattern values in SSIS environments. Attendees will also learn how to do Pattern Profiling and explore other profiling metadata using the Melissa Community Edition SSIS Plugin.
For free webinar registration, click here or call 1-800-MELISSA (635-4772).