Is there any tutorial how datawarehouse of AdventureworksDW is developed using SSIS from AdventureWorks database..basically am new to Datawarehouse so plan of practising it

Question

Is there any tutorial  how datawarehouse of AdventureworksDW is developed using SSIS from AdventureWorks database..basically am new to Datawarehouse so plan of practising it using Adventurework database...

Is there any front end application to work with Adventurework database for OLTP ...

So that i can add some data to Adventureworks database and i can do datawarehousing using SSIS

---

ilikemicrosoft

Answer 1

The tutorials are in the product documentation (called SQL Server Books Online).  The starting point for tutorial is here: http://msdn.microsoft.com/en-us/library/ms167593.aspx.

---

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 2

see this thread AdventureWorksDW How-To

 and get the book "Microsoft Data Warehouse Toolkit from Kimball Group "

in addition this article may be interesting for you SQL Server Best Practices Article

---

Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.