In the following sections, you'll learn how to build a sample warehouse with Oracle Warehouse Builder. In particular, you will learn how to perform the following:
Working with Design Center, the primary tool of Warehouse Builder
Creating a project for a warehouse
Defining source and target modules
Creating dimensions and cubes
Populating dimensions and cubes with data
On Windows, to launch Design Center, you can select Start | Programs | OWB_ORACLE_HOME | Warehouse Builder | Design Center from the Windows Start menu. On a Linux platform, run the following script OWB_ORACLE_HOME/owb/bin/unix/owbclient.sh
.
As a result, you should see the Design Center Logon dialog prompting for a workspace User Name and Password as well as the underlying database connection details. The dialog is shown in the following screenshot:
Looking at the previous screenshot, you may notice that owbuser is used as the User Name here...