Data Management & Warehousing

Tag: Data Quality

  • Basic Data Quality Checks

    —

    by

    macleanwalker
    in

    This article looks at basic data quality audit that can be done within a database. Examples are given using Oracle syntax however the techniques can also be applied to other databases   Introduction The following article discusses some of the data quality issues that can be addressed by manual scripts on a copy of the…

  • Auditing Data Cleaning Updates

    —

    by

    macleanwalker
    in

    How to track what has been updated by data cleaning processes The Problem A common problem when building a data warehouse is to track and audit which records have had data quality updates or cleaning applied to them. A simple method is to add a bitmap that reflects the data quality updates have been applied.…