question

sunil2711 avatar image
sunil2711 asked

Data warehouse Architecture

Hi All, I started working on new data warehouse project by using SQL Server(SSIS,SSAS) Does anyone have sample server architecture design document for data warehouse project.
ssissqlserveretldatawarehousearchitecture
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Could maybe use Microsoft's **Fast Track Data Warehouse Reference Guide for SQL Server 2012** as a starting guide. But be aware that it was written for SQL 2012 : https://msdn.microsoft.com/en-us/library/hh918452.aspx It might give you enough to start asking more questions.......
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sunil2711 avatar image sunil2711 commented ·
Thanks Kev
0 Likes 0 ·
sjimmo avatar image sjimmo commented ·
It is difficult to build a generic datawarehouse as each is built to the business. But this is a good place to start.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.