Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems. The primary use for OWB is consolidation of heterogeneous data sources in data warehousing ...Full description
Please note that the content of this book primarily consists of articles available from Wikipedia or other free sources online. Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems. The primary use for OWB is consolidation of heterogeneous data sources in data warehousing and data migration from legacy systems. Further it offers capabilities for relational, dimensional and metadata data modeling, data profiling, data cleansing and data auditing. Whereas the core functionality is part of the Oracle database since version 10gR2, some of the latter features are sold separately as options. OWB uses a variant of Tcl over Java and PL/SQL called OMB+. Oracle Warehouse Builder was built from the ground up in Oracle, it was first released in January 2000 (release 2.0.4).