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

Download

ProjectREAL ETLDP.doc
4.89 MB
Microsoft Word file
Updated : January 5, 2007