Expand All
Automate Testing of Your Stored Procs
Streamline Your Database Setup Process with a Custom Installer
Stop SQL Injection Attacks Before They Stop You
Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005
Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005
AMO Lets You Dig Deeper into Your Data from Your Own Applications
Make Sense of Your Web Feedback using SQL Server 2005
Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
Unearth the New Data Mining Features of Analysis Services 2005
Using XQuery, New Large DataTypes, and More
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

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

© 2016 Microsoft