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


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