May 28, 2008 05:28 PM

Data Warehousing: Degenerate Dimensions

Mapping control numbers from the OLTP database to the data warehouse
Rating: (0)
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

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

The Essential Guide to SQL Server 2005 BI
A Essential Guides by Dell
A Jump Start to SQL Server BI
A EBooks by Microsoft
More
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS