Oracle Warehouse Builder (OWB) is Oracle's comprehensive tool for ETL (extract, transform and load), fully integrated relational and dimensional modeling, data quality, data auditing, and full life cycle management of data and metadata. It provides an easy to use, graphical environment to rapidly design, deploy, and manage data integration projects and business intelligence systems.
This series of OBE tutorials walks you through a data profiling exercise, allowing you to correct data based on detected business rules. In addition, the tutorials show how you can match and merge duplicate data using Warehouse Builder. Other topics include ETL on complex data types, modeling of schemas in the Oracle database (includes partitioning, indexing, and compression). And finally, the tutorials show how to augment Warehouse Builder with Experts, allowing you to encapsulate business knowledge into Warehouse Builder.
Click the links below to open each tutorial. The setup tutorial is a prerequisite for all of the other tutorials; once the setup tutorial has been completed successfully, you may perform the rest of the tutorials in any order.