PASS Community Summit 2008: Program Sessions (Business Intelligence)

The Kimball Method is a proven methodology for building a data warehouse / business intelligence system. This session offers practical advice on how to design and implement the ETL application for your DW/BI system in SQL Server 2008. Which are the most valuable new features of the SQL Server 2008 Database Engine and Integration Services for you to include in your ETL design? If there are several ways to solve a problem — and there always are! — how do you decide what's the best approach in your circumstance? In this session, Joy will illustrate common design techniques for the ETL system that populates a Kimball Method data warehouse. We'll demonstrate components of the ETL system, including how to: - Design the ETL system - Extract changed data - Manage changes in dimension attributes - Implement the fact table surrogate key pipeline

Register Now for PASS Community Summit 2008!