Post reply

Data Warehouse Basics

  • May 11, 2007 at 4:55 pm

    #172374

    I am new to Data Warehousing and was going through the 'SQL Server 2005 Analysis Services Step by Step' book from MS Press and suddenly realized that I don't really know the difference between a normalized OLTP database and an OLAP database.

    So here is my question:

    I have a flat file extract of a RDBS (not SQL). I have a bunch of T-SQL scripts to load it into a SQL Server database, 1:1 table for table with the OLTP source data.

    What is the next step? Are there tools to derive fact tables and dimension tables from a normalized OLTP database or is it a manual process. Any references online on how to convert OLTP to OLAP Data Warehouse?

  • May 13, 2007 at 4:35 pm

    #706074

    here's one presentation i found when googling 'example OLTP to OLAP schema' there's quite a few more

    http://www.educationdw.com/tutorial/DW_navathe.pps

    Steve.

  • May 15, 2007 at 4:36 pm

    #706625

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply