Clean Data Options for Oracle Data Integrator Enterprise Edition
By Dain C. Hansen on Feb 17, 2009
I thought I would reference an excellent blog that I saw the other day entitled: "Comparing ODI and OWB Data Quality and Profiling Options" by Mark Rittman.
Mark outlines the unification of Oracle Data Integrator Enterprise Edition and the resulting deployment options customers will be able to select from for achieving consistency and quality for their data-centric architectures. Specificallly he describes how to discern between using Data Quality options from either Oracle Data Integrator or Oracle Warehouse Builder Enterprise ETL options.
He walks through several examples using each component for profiling data, how to apply cleansing for data flows, and extending business rules.
In his summary, he concludes that the two tools are useful for different scenarios. Oracle Data Integrator’s Data Quality options are easy to use and offer the flexibility for both non-Oracle as well as Oracle sources, whereas Oracle Warehouse Data Quality options are uniquely fitted to Oracle targets, which offer nice options for auto-generating corrections and suggest business rules the auto-detected metadata.
For more information on Data Quality using Oracle Data Integrator, take a look at Oracle Data Quality on OTN for more detail. You can download the same tutorials that were used in this article from Mark Rittman.