O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

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 8 Managing Changing Data

Many data sources are simply a snapshot of the current state of some part of your enterprise. If you reload the dimension tables of your data warehouse directly from these sources, all reports and cubes appear as if the current state is the way things have been for all time. This may be alright if you are recording birthdays, but it can seriously mislead you if you are looking at something such as a customer’s credit rating or which salesperson is (or was) responsible for a given territory.

When some of the attributes of a dimension record change over time, the dimension is called a slowly changing dimension (SCD). For example, customers or employees change their names, the cost of production for a product ...

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