What is Oracle Warehouse Builder?
Oracle Warehouse Builder (OWB) is a framework for creation of extraction, transformation, and loading scripts for populating an operational data store, a data mart or a data warehouse. OWB also includes a component to design the target data warehouse / data mart / operational data store. The design component can be used to create data warehouses designed as star schema (including aggregations / summary levels with multiple hierarchies) or warehouses / operational data stores as third normal form.