Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2006-09-06 : 08:54:02
|
| I will try and explain this the best I can. I have a customers table that I want to store monthly historical data for. Currently the table consists of about 12 colums, with a large number of them being foreign keys. If I want to store historical data, meaning some of these foreign key entry values could change month/month, should i just add like a month end data column to the customer table, and just import the data fresh each month, this way i can always reference what an account looked like on a given month end date? Or is there a better method of doing this? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-06 : 09:00:12
|
| This sounds like a Slowly Changing Dimension problem. You should search for that term on Google for articles on that subject.This article is a good place to start:http://www.dbmsmag.com/9604d05.htmlCODO ERGO SUM |
 |
|
|
|
|
|
Historical Database Design