Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Oracle Warehouse Builder 11g R2: Getting Started 2011

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

Product type Book
Published in May 2011
Publisher Packt
ISBN-13 9781849683449
Pages 424 pages
Edition 1st Edition
Languages

Data warehouse design in OWB


The Warehouse Builder contains a number of objects, which we can use in designing our data warehouse, that are either relational or dimensional. OWB currently supports designing a target schema only in an Oracle database, and so we will find the objects all under the Oracle node in the Projects tab. Let's launch Design Center now and have a look at it. But before we can see any objects, we have to have an Oracle module defined to contain the objects. If you've been following along and working through the examples in this book, so far you should have one module already defined for the ACME website orders database—ACME_WS_ORDERS. We created this in the last chapter when we imported our metadata from that source. If that is the case, our Projects tab window will look similar to the following:

Creating a target user and module

We need a different module to create our target objects in. So before going any further, let's create a new module in the Projects tab for...

lock icon The rest of the chapter is locked
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 $15.99/month. Cancel anytime}