O'Reilly logo

Star Schema The Complete Reference™ by Christopher Adamson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 11Transactions, Snapshots, and Accumulating Snapshots

Each star schema in the preceding chapters features a fact table that measures activities. This kind of fact table is known as a transaction fact table. As you have seen, it supports a wide variety of analytic possibilities with great efficiency and can be used to capture detailed granular information about a process. Some facts, however, cannot be easily studied using this kind of design, and others cannot be accommodated at all.

This chapter introduces two additional kinds of fact table: the snapshot and the accumulating snapshot. It begins with a review of the transaction fact table design, highlighting some key characteristics covered in previous chapters. Snapshots and accumulating ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required