Data Profiling and Automated Cleansing Using Oracle Warehouse Builder 10g Release 2

Overview

Most organizations build a data warehouse to provide an integrated, reliable, and consistent "Single version of the truth." Data is usually sourced from a number of systems and has to be extracted, cleansed, and integrated before being made available for users to query. The quality of the data loaded into the data warehouse is often variable, however, and for that reason, historically the process of profiling the source data has been a time-consuming, manual process that has required either lots of experience with SQL*Plus or the purchase of an expensive third-party tool. With the release of Oracle Warehouse Builder 10g Release 2, however, the ability to profile the data is built into the tool and no knowledge of SQL*Plus is required.