Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

How to Roll your Own Value, RegEx and SoundEx Pattern Profiler in SSIS

Sponsored by - MelissaData

Webcast Abstract

Data Profiling is the foundation for successfully implementing a comprehensive data quality regimen. Included in Data Profiling is the recognition of patterns in your data, which plays an essential role in the validation of data. Value and Regular Expression Pattern Profiling ensures that strings are well-formed, for data types that require to be in a specific format. While SoundEx Patterns strengthens the detection of duplicate data, through the use of a fuzzy algorithm.

In this Webinar, learn how to leverage Value and RegEx Pattern Profiling to expose formatting problems to different data types, improve the detection of duplicates through SoundEx Patterns and how to apply them in your data validation procedures. Also, see how to roll your own Value, RegEx and SoundEx Script Component for generating pattern values in SQL Server Integration Services.

Speaker - Joseph Vertido

Joseph Vertido is a Data Quality Analyst at Melissa Data, Joseph Vertido is an expert in the field of data quality. He has worked with numerous clients in understanding their business needs for data quality, analyzing their architecture and environment, and recommending strategic solutions for how to successfully integrate data quality within their infrastructure. He has also written several articles for implementing data quality solutions and techniques. Joseph holds a degree in Computer Science from the University of California, Irvine.

To access materials please fill out the form below.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.



More SQL Server Solutions











Learn more about SQL Server tools