Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle Warehouse Builder 11g: Getting Started

You're reading from   Oracle Warehouse Builder 11g: Getting Started Extract, Transform, and Load data to build a dynamic, operational data warehouse

Arrow left icon
Product type Paperback
Published in Aug 2009
Publisher Packt
ISBN-13 9781847195746
Length 370 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Bob Griesemer Bob Griesemer
Author Profile Icon Bob Griesemer
Bob Griesemer
Arrow right icon
View More author details
Toc

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...

You have been reading a chapter from
Oracle Warehouse Builder 11g: Getting Started
Published in: Aug 2009
Publisher: Packt
ISBN-13: 9781847195746
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image