Solved

What is a slowly changing dimension?

Posted on 2013-02-05
1
333 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Log Backup 2 21
Joining Two Tables In SQL and combining records 6 51
AWE-based memory on 32-bit servers 1 23
Extract string portion 2 0
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

932 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

9 Experts available now in Live!

Get 1:1 Help Now