Search
InstantDoc ID
GO

Browse By: Author | Issue

May 28, 2008 05:28 PM

Data Warehousing: Degenerate Dimensions

Mapping control numbers from the OLTP database to the data warehouse
Rating: (0)
Michelle A. Poolet
SQL Server Magazine
InstantDoc ID #98722
Executive Summary: Degenerate dimensions are control numbers that are stored in the fact table of the data warehouse. Control numbers enable you to see which items in a fact table originate from the same order or invoice. Although control numbers are mapped to the fact table like other attributes from the OLTP database, they aren't treated as keys.
...

...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

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

© 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.