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 |
|
learntsql
524 Posts |
 Posted - 2012-02-21 : 04:48:28
|
| Hi All,We are building some datawarehouse system in SQl Server.Please tell me the process of loading fact and dimension tables in SQL Server environment.TIA. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-02-21 : 07:11:59
|
| A bit of a big subject to condense into a reply, best thing to do is to pick up an analysis services guide or a datawarehousing book. The basics are:- Design your schemas (star, snowflake or anything in between- use T-SQL or SSIS to load your data or any other tool at your disposal- make sure your data is consistent enough and handle null values etcA proper design will make the end result robust and is probably the most important part of the process, get this wrong and you will be fixing issues for years to come, get it right and adding functionality will be easier. |
 |
|
|
learntsql
524 Posts |
Posted - 2012-02-21 : 07:25:11
|
| ThanQ RickD.Experts could you please suggest some books.TIA. |
|
|
|
|
|
|
Fact and Dimension loading process