View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 07:53 PM
Ronald S. Cook
 
Posts: n/a
Default Create star schema in SQL Server 2005?

Consider me brand new to data warehousing. I'm looking for a simple,
real-world example taking a simple transactional table, and getting all
"data warehouse" on it.

I know there's a star schema to design, but wouldn't I just do that within a
regular (OLTP) database?

We're looking to get into data warehousing in baby steps. I'm just trying
to be able to put an extremely simple real-world example in front of my boss
to explain what we would do. I.e. not concepts, but 1) start with
tblEmployee in the OLTP database... step 2...

Any help at all would be greatly appreciated.

Thanks,
rsc


Reply With Quote