Data Warehousing

[mukund]

Hi
Has anybody worked on Data Warehousing solutions ?
If yes, can you tell as to how to go about it ?
I have worked on SQL Server 7, for pat one year an thinking of exploring Data Warehousing.


Regards,
Mukund.

 

[JayKusch]

This is a pretty tall order. there are many ways and styles of datawarehouses from snowflake to star to multi-dimensional cubes. may need to grab a book on the subject.
Microsoft Press has a pretty good book on the construction of Datawarehouses in SQL7 called "Data Warehousing with SQL Server 7.0 - Technical Refrence". Good Luck!

 

[JayKusch]

Here is a good reference to your project. Enjoy!

http://msdn.microsoft.com/library/d...n-us/dnsql2k/html/Sql_DWDesign.asp?frame=true