Summary

In this chapter we've finished discussing some additional features of the tool. These are not necessarily essential to the initial development of a data warehouse, but are nevertheless valuable features to have available for further development and maintenance. These include features such as metadata change management, which become critical as more and more changes are required to a data warehouse. The Recycle Bin, the Cut, Copy, and Paste features, Snapshots, and the Metadata Loader all assist greatly in our efforts to control the changes we have to make and to keep a track of prior revisions.

Another valuable feature is the ability to keep the objects synchronized with the operators in the mappings that refer to those objects. Also, we can automatically update objects that are bound together, such as dimensions and the tables used to implement them. These features will assist greatly in the task of making changes to our data warehouse, which will inevitably need to be done in any...