Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Creating a Data Warehouse

SQL Server 2000

Creating a data warehouse is a significant project with a number of steps. The topics in this section address these steps.

Topic Description
Designing a Data Warehouse Describes considerations specific to designing data warehouses and the use of dimensional modeling.
Creating the Data Preparation Area Describes the creation of the relational database used to prepare data for the data warehouse.
Creating the Data Warehouse Database Describes the creation of the relational database that holds the data warehouse data.
Extracting Data from Operational Systems Describes the process of extracting data from operational systems into the data preparation area.
Cleansing and Transforming Data Describes the process of cleansing and transforming data in the data preparation area before loading the data into the data warehouse.
Loading Data into the Data Warehouse Database Describes the process of loading data into the data warehouse database from the data preparation area.
Preparing Presentation Information Describes the process of preparing data in the data warehouse for presentation to users.
Distributing Data to Data Marts Describes the process of distributing data from the data warehouse to data marts.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft