Chapter 8. Validating, Generating, Deploying, and Executing Objects

We have reached the last step in the process of building our data warehouse. We've done a large amount of work so far, which includes designing target schemas, creating objects in the Warehouse Builder, and creating mappings to load data into our target. However, we have yet to actually create a single real database object. What we have is the complete design stored in the Warehouse Builder. Let's think of ourselves as architects of new houses; only instead of designing a house, we're designing a data warehouse. Before any house can be physically built, someone has to design it and create a model of the house that the builders will then use for construction. That's what we've been doing up until this point, that is, creating the model of our data warehouse.

Now we are at the point where the model is complete and we're ready to actually build the data warehouse in an actual database, and load data into it. So, we get to be...