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 |
|
kellog1
Starting Member
35 Posts |
 Posted - 2010-01-01 : 23:57:49
|
| Guys, Can anybody tell me how to design dimensional model based on point in time architecture database design? |
|
|
dportas
Yak Posting Veteran
53 Posts |
Posted - 2010-01-03 : 05:16:24
|
| If you don't know how to design a "dimensional" model then I don't think you should assume that it's the right thing to do. I guess your intention is to create a Data Warehouse. If you haven't done DW projects before then it's not really something I'd recommend you do alone without help because mistakes are easy to make and can be very expensive to fix.I would generally recommend that your warehouse data model should be a Normal Form model, i.e. at least BCNF/5NF. But first you must identify which pieces of data you need from your point-in-time data source. |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2010-01-09 : 11:49:54
|
| 1. identify the business process2. pick the grain3. pick the dimensions4. identify the factsRAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
|
|
|
PTA Database Design