Reader small image

You're reading from  Oracle Warehouse Builder 11g: Getting Started

Product typeBook
Published inAug 2009
PublisherPackt
ISBN-139781847195746
Edition1st Edition
Right arrow
Author (1)
Bob Griesemer
Bob Griesemer
author image
Bob Griesemer

Bob Griesemer has over 27 years of software and database engineering/DBA experience in both government and industry, solving database problems, designing and loading data warehouses, developing code, leading teams of developers, and satisfying customers. He has been working in various roles involving database development and administration with the Oracle Database with every release since Version 6 of the database from 1993 to the present. He has also been performing various tasks, including data warehouse design and implementation, administration, backup and recovery, development of Perl code for web-based database access, writing Java code utilizing JDBC, migrating legacy databases to Oracle, and developing Developer/2000 Oracle Forms applications. He is currently an Oracle Database Administrator Certified Associate, and is employed by the Northrop Grumman Corporation, where he is currently a Senior Database Analyst on a large data warehouse project.
Read more about Bob Griesemer

Right arrow

An overview of Warehouse Builder Design Center


The Design Center is the main graphical interface that we will be using to design our data warehouse, but we also use it to define our data sources. So let's take some time at this point to go over the user interface and familiarize ourselves with it. We launch Design Center from the Start menu under the Oracle menu entry, as shown in the following image:

The Design Center must connect to a workspace in our repository. To review briefly, we discussed the architecture of the Warehouse Builder in Chapter 1. This included the repository in which we created a workspace and a user, who would be the owner of the workspace. We used the Repository Assistant application to configure our repository and create that user. The repository is located in the OWBSYS schema that was the pre-installed schema the database installation provided for us. The user name chosen was acmeowb and the workspace name was acme_ws. Now it's time to make use of this user and...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Oracle Warehouse Builder 11g: Getting Started
Published in: Aug 2009Publisher: PacktISBN-13: 9781847195746

Author (1)

author image
Bob Griesemer

Bob Griesemer has over 27 years of software and database engineering/DBA experience in both government and industry, solving database problems, designing and loading data warehouses, developing code, leading teams of developers, and satisfying customers. He has been working in various roles involving database development and administration with the Oracle Database with every release since Version 6 of the database from 1993 to the present. He has also been performing various tasks, including data warehouse design and implementation, administration, backup and recovery, development of Perl code for web-based database access, writing Java code utilizing JDBC, migrating legacy databases to Oracle, and developing Developer/2000 Oracle Forms applications. He is currently an Oracle Database Administrator Certified Associate, and is employed by the Northrop Grumman Corporation, where he is currently a Senior Database Analyst on a large data warehouse project.
Read more about Bob Griesemer