Chapter 9. Extra Features

Congratulations on having made it this far and completing the data warehouse implementation! We've now covered all the Warehouse Builder basics that we need to begin building our data warehouses for our organizations. This chapter will deal with some extra topics that can help us get the most out of what we've learned so far and improve our use of the Warehouse Builder. The focus will be on those features that we will find useful as we create more complex data warehouses, and are faced with making changes and updates.

Metadata change management is an important practice we'll want to employ as we make more and more edits and changes to our data warehouse over time, and the Warehouse Builder includes a number of features that can help us with this. We'll look at the Recycle Bin for saving deleted objects, copying and pasting objects to make copies for backup or as the basis for new objects, taking snapshots of objects to save the state at a point in time, and the...