Getting started with Oracle Warehouse Builder

Oracle Warehouse Builder offers a set of graphical user interfaces allowing you to implement a data store, either relational or dimensional, integrating and consolidating data from a variety of data sources. During building such a data store, also called a warehouse, you create a set of metadata objects within a workspace hosted on an Oracle database.

Oracle Warehouse Builder provides broad data integration facilities, making it a breeze to create Business Intelligence metadata for a wide range of data sources. You might want to use this powerful tool if, for example, you need to derive data from different database systems such as DB2, Informix, SQL Server, and Sybase, as well as flat files, XML, Web, and other disparate sources.

Once the data is derived, it will be automatically transformed into the data structures you have defined. It's interesting to note that you can use the Oracle Warehouse Builder's import facilities to make those data...