CHAPTER 17Design and ETL

One of the most difficult tasks in data warehousing is ETL development. The process that loads a star schema varies significantly from implementation to implementation. It is influenced by the software tools used, the latency profile of the solution, and the data architecture of the data warehouse. Despite these variations, every load process must perform certain fundamental activities. This chapter explores how design adjustments can aid these activities.

The process of loading a dimension table is made complex by the need to handle slowly changing dimensions. It will be necessary to identify new and changed data and process it accordingly. This is more difficult than it may seem, since what constitutes a “change” may ...

Get Star Schema The Complete Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.