Solved

What is a slowly changing dimension?

Posted on 2013-02-05
1
332 Views
Last Modified: 2016-02-11
Please explain what a slowly changing dimension is and how it is used!
0
Comment
Question by:rhservan
1 Comment
 
LVL 37

Accepted Solution

by:
ValentinoV earned 300 total points
ID: 38858395
There are several different types of SCD, I assume you're referring to a slowly changing dimension of type 2? (the most common one)

The easiest explanation would be: it's a dimension with a history.  Imagine a Product dimension with one of the attributes being ProductName.  If you want to track changes to ProductName, you can make this a SCD of type 2.  That way you know that up until a certain data, "Product X" was called "Product X" and from that date on it was renamed to "Product X2", but in essence it is actually still "Product X".  The business key for the product would remain unchanged (important!!) and that's how you'd link the two records.

More info: [Wikipedia]: Slowly changing dimension
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now