Search
InstantDoc ID
GO

Browse By: Author | Issue

December 18, 2007 06:18 PM

Data Warehousing: Slowly Changing Dimensions

When change occurs in your data warehouse, how will you react?
Rating: (0)
Michelle A. Poolet
SQL Server Magazine
InstantDoc ID #97409

Executive Summary:
With slowly changing dimensions you can respond in one of three ways. You can overwrite the old data with the new data, which works best when the old data has no significance and can be discarded. You can create a new dimension record for the time period that defines the change, which works best with changes that neatly partition history. You can also create an "old value" column in the slowly changing dimension to store the previous value, which works best with soft changes.

Cha...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

A Jump Start to SQL Server BI
A EBooks by Microsoft
Moving SQL Server to the x64 Platform
A EBooks by AMD
The Essential Guide to SQL Server 2005 BI
A Essential Guides by Dell
Top 8 Considerations for Sizing a Microsoft SQL Server BI Solution
A Tip Guides by Hewlett-Packard
More

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.