New Features


Oracle Warehouse Builder 10g Release 2 is a single, comprehensive tool for all aspects of data and metadata management. It provides data quality, data auditing, fully integrated relational and dimensional modeling, and full life cycle management of data and metadata. It supports data integration and management activities including:

Providing extraction, transformation, and loading (ETL).
Consolidating data from disparate data sources.
Migrating data from legacy systems.
Data modeling of relational and dimensional structures
Designing and managing corporate metadata.
Cleaning data to provide quality information.
Profiling and auditing data quality.

The three main release themes are:

Enabling Quality Information

Enabling Business Intelligence

Enabling Expertise Capture

The major features within these areas are:

Data profiling. Warehouse Builder now offers a complete data profiling and correction solution. With data profiling, you can discover and measure defects in your data prior to and during the process of creating your data warehouse or BI application.

Once you profile your data, you can automatically derive business rules and correction mappings to clean data, derive quality indices such as Six Sigma, and use auditors to continuously monitor data quality. This functionality ensures your data quality efforst are sustained and continuous.

  zoom in

Relational and dimensional data object designer. Warehouse Builder introduces a new Data Object Editor to create, edit, and configure relational and dimensional data objects. This allows the data modeler to use a single interface regardless of whether the design asks for specialized dimensional objects or the latest partitioning features on tables.

As part of the extensions to the data object designer, advanced data type support is also added. Warehouse Builder now supports custom database types, varrays and nested tables. XML data types and Spatial data types are also handled and can be moved around via ETL.

  zoom in
 Complete slowly changing dimensions (Types I, II, III) support. Warehouse Builder fully supports slowly changing dimensions that store and manages both current and historical data over time in a data warehouse. Warehouse Builder allows you to design a dimension in any of the three types. Once designed ETL will transparently handle the data to adhere to the SCD type of the dimension.   zoom in
 Oracle OLAP integration. With the 10gR2 release Warehouse Builder extents the support for Oracle OLAP into modeling and direct maintenance utilizing the new OLAP features such as compressed cubes and partitioning. Warehouse Builder now allows you to directly load any source data into the OLAP option, eradicating the need of a temporary staging area for relational data.   zoom in

Transportable Modules. Enable youto extract large amounts of data from remote Oracle databases while enjoying highest performance possible. OWB’s Transportable Module feature uses one of the mechanism in Oracle Database:

  • Transportable Tablespace in 9i and 10g or
  • Datapump in 10g only
  zoom in
 Pluggable mappings. To save time and labor when designing mappings, this new feature enables you to reuse a mapping's data flow. You can create a pluggable mapping around the portion of the flow you want to reuse. The pluggable mapping is a reusable grouping of operators that has the advantages of a single operator. You can publish pluggable mappings to a library so that other designers can use them, or keep them private.   zoom in
 Built-in scheduling. In the Paris release you can define your own schedules in Warehouse Builder and associate your executable objects with the schedules. You can associate an executable object (such as a mapping or a process flow) with a schedule. Upon deployment, Warehouse Builder deploys the schedule into the database scheduler. Schedules are defined by Start date and time, Schedule frequency, Repeat interval, Calendar expression, End date and time.   zoom in
Sophisticated Lineage and Impact Analysis. Have been greatly enhanced to show impact and lineage at the level of individual attributes, exploding mappings, generating worst-case scenario diagrams, including User-Defined objects created outside of OWB. Additionally you will have change propagation for ETL objects such as mappings, making change management even easier.
  zoom in
 Business intelligence objects derivation. Warehouse Builder enables you to derive and define Business Intelligence (BI) objects that integrate seamlessly with Oracle's Business Intelligence tools such as Discoverer and Business Intelligence (BI) Beans.   zoom in
 Experts. Experts are solutions that enable advanced users to design solutions that simplify routine or complex tasks that end users perform in Warehouse Builder. You can design these solutions in the Expert Editor which resembles
the Process Flow Editor and shares many of the same commands and navigational tools.
  zoom in
 User-defined objects and icons. Warehouse Builder now offers complete support for user defined types including objects, varrays, and nested tables. This enables you to use more elaborate data storage and transaction formats such as those used to support real-time data warehousing.   zoom in

ERP Integration. With this new release of Warehouse Builder, a host of new features are added in the ERP integration area. Connectors for Oracle eBusiness Suite and PeopleSoft ERP are added to the product. These connectors allow you to import the metadata from the ERP systems in a way that makes business sense to the developers. Metadata is grouped in the approriate modules and business names are shown.

The SAP Connector is extended and now allows for variable substitution within ABAP and direct deployment and execution of the ABAP. To allow even better performance additional features are added.

  zoom in
 Security administration. Beginning with Oracle Warehouse Builder 10g, you can choose to apply no metadata security controls or define your own metadata security policy. You can define multiple users and apply full security or implement your own security strategy based on the Warehouse Builder security interface.   zoom in

Various Changes

  • Simplified Install and Setup: In step with the Oracle Database 10g theme of ease of management, Warehouse Builder set up and installation procedures have been simplified. In many cases requiring a single repository to manage both runtime and design metadata.
  • Unified metadata browser environment: All you metadata, whether runtime or design related can now be viewed from a single browser starting point
  • OMB Extensions: By adding OMU commands you can now launch Warehouse Builder User Interface components from a scripted environment. See experts for more details.
  • Certification: With Oracle Database 10gR2 being delivered, Warehouse Builder will be certified on both Oracle Database 10gR1 and 10gR2 and RAC for both versions.


Oracle Warehouse Builder 10g Release 2 is a single, comprehensive tool for all aspects of data and metadata management. It provides data quality, data auditing, fully integrated relational and dimensional modeling, and full life cycle management of data and metadata.

Top of Page

Oracle Corporation

Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065

Worldwide Inquiries:
Fax +1.650.506.7200

Copyright Oracle Corporation 200 4
All Rights Reserved

This document is provided for informational purposes only,
and the information herein is subject to change
without notice.  Please report any errors herein to
Oracle Corporation.  Oracle Corporation does not provide
any warranties covering and specifically disclaims any
liability in connection with this document.

Oracle is a registered trademark of Oracle Corporation.

All other company and product names mentioned are used
for identification purposes only and may be trademarks of
their respective owners.