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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2010-01-20 : 22:28:33
|
| Hi,We are planning built a new data mart which receives feeds from other datamart that is already in place. My architect has come up with the new data model for this datamart and to be precise what are the questions that should come to my mind immediately after data model is built.Certain question that comes to my mind are:1. frequency of the load.2. star/snowflake3. The attributes that should receive as a feed.4. Flat file - demilted/fixed.Similiarly do you have any thought process on this. Just post the questions you had experienced in your previous projects as I'm quite new to this scenario. This will help me to go to the next level and ease on understanding. |
|
|
|
|
|
Database design