O'Reilly logo

Oracle Warehouse Builder 11gR2: Getting Started 2011 by Bob Griesemer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we dove right into creating our three dimensions and a cube using the Warehouse Builder Design Center. We used the wizards available to help us out, as well as investigated the flexibility to manually create, view, and edit objects using the data object editors for dimensions and cubes. In a relatively short amount of time, we were able to design a data warehouse structure that could be used as is, or expanded to support more detailed information.

Now that we have our sources defined and our targets designed, it's time to start thinking about loading that target. Next, we'll look at some Extract, Transform, and Load (ETL) basics to lay the groundwork for designing the ETL we'll use to actually load data into our data warehouse. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required