Project REAL: Business Intelligence ETL Design Practices
Published: September 1, 2005 | Updated: January 5, 2007
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 |
