SQL Data Quality & Regular Expression


  • I am beginning a data quality project and am looking for the best to the audit the data in individual columns.  Some columns are simple like a phone, others are more complex like a combination of city, state and zip.  We do have some custom scenarios, but they shouldn't be any more complex than validating an address.

    My question is two fold, what is the best to validate or check the data we have based on regular expressions and custom rules (each business unit has different rules)?  Second, what is the best way to communicate this to my end users so they can make the necessary corrections??



    Tuesday, August 27, 2013 1:52 AM