Summary

In this chapter we dove right in to 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 Editor. 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.