Project REAL: Business Intelligence ETL Design Practices
Read about SQL Server 2005 Integration Services in action. Used in the business intelligence reference implementation called Project REAL, Integration Services demonstrates a high-volume and real-world based extraction, transformation, and loading (ETL) process. This ETL solution supports a multi-terabyte data warehouse, and contains representative data processing, configuration, and administration mechanisms of a large warehouse initiative.
Included in this document:
-
Introduction
-
Project REAL ETL Objectives
-
Summary
-
Data Profile
-
Integration Services Development Environment
-
-
Project REAL ETL Solution Highlights
-
ETL Auditing and Logging
-
Dynamic Package Configuration Design
-
Data Processing Architecture
-
Dimension Table ETL Processing
-
Fact Table ETL Processing
-
Analysis Services Processing
-
Advanced Data Processing Concepts
-
-
Performance Testing and Analysis
-
Partitioned Table versus Multi-Table Performance
-
Database Snapshot Overhead
-
Distributed SQL Server Architecture versus Consolidated Architecture
-
-
Conclusion
Download
ProjectREAL ETLDP.doc
4.89 MB
Microsoft Word file
Updated : January 5, 2007