Solved

What is a slowly changing dimension?

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

861 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