Star Schema The Complete Reference

CHAPTER 18How to Design and Document a Dimensional Model

There is great diversity in the ways organizations leverage the potential strategic value of dimensional design. Equally diverse are the development methodologies that IT organizations use to structure their work. Despite all these differences, the development of a dimensional design always calls for some common activities, and the deliverables share some common features.

This chapter will guide you through the process of designing and developing a dimensional model. It is not geared to any single architecture or any single methodology. Instead, it looks at the common tasks required in any design effort, whether conducted as part of an upfront enterprise strategy project or embedded within ...