How to design Data Warehouse for Traditional OLTP System

I am successfuly runing my relational database system designed in SQL 2000, and it has data for last 5 years, runing smoothly.

Now, i want to create a data warehouse for my database... How do i create?

From where to get start?

Any Sample Project that demonstrate How to design DW for OLTP system. Any Example that converts Northwind DB to DW?

There are several ways for you to start. You can read a little bit about Start and Snowflake schemas.

You can take a look at the design of AdventureWorksDW sample database and AdventureWorks sample AS project.

You can also try and take a run a cube wizard creating a new cube without using datasource. And once you've defined a cube structure, BI Dev Studio will generate a relational DB schema for you.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.