Question
-
Thursday, March 14, 2013 2:12 PMQuestion 3: Take the following timeline. If our customers’ name changes over the years how do we preserve history in our Dimensional Model? In other words, how do we preserve our customers name at the time a sale was made? Provide two ways we can do this
All Replies
-
Thursday, March 14, 2013 3:12 PM
This is something which might want to achieve using Change Data Capture.
http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx
Narsimha
- Proposed As Answer by Phaneendra Babu Subnivis Saturday, March 16, 2013 7:17 PM
-
Thursday, March 14, 2013 3:29 PM
In a dimensional model, you'll need a slowly changing dimension table. I suggest you look up the term, as I would hate to simply answer your question directly seeing as it looks like it's course work of some sort. Types 2 and 3 should answer your question.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, March 21, 2013 7:48 AM
.png)
