MSDN Architecture Webcast: Using SQL Server 2005 Integration Services to Populate a Kimball Method Data Warehouse (Level 200)  

How do you combine the tasks and transforms offered by Microsoft SQL Server 2005 Integration Services (SSIS) into a real extraction, transformation, and loading (ETL) system? In this webcast, we present design patterns for building an application that is maintainable, auditable, and scalable to populate your dimensional Kimball Method data warehouse and Microsoft SQL Server 2005 Analysis Services database. Learn best practices for overall system design, for populating dimension and fact tables, and for populating the audit dimension.

Presenter: Joy Mundy, Presenter, Kimball Group

Joy Mundy has focused on data warehousing and business intelligence (BI) since the early 1990s, specializing in business requirements analysis, dimensional modeling, and BI systems architecture. Joy cofounded InfoDynamics, LLC, a data warehouse consulting firm, then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse. Before returning to consulting in 2004, Joy worked at Microsoft managing a team that developed best practices for using Microsoft products and technologies as a platform for building BI systems.

To avoid possible problems, we suggest you temporarily disable pop-up blocker software before viewing the webcast.

View other sessions from Business Intelligence with SQL Server 2005: Transform Data into Decisions.


Questions?  Feedback?  Use Webcast Contact Us