Main Content

Data Warehouse ETL with SSIS

A talk by Todd McDermid

About the Talk

May 13, 2010 2:30 PM

1160 Dublin Rd Suite 500, Columbus, OH 43215

1160 Dublin Rd Suite 500, Columbus, OH 43215

Microsoft designed Integration Services with Data Warehouse ETL processes in mind, so loading one should be pretty easy. It's not that bad, but there are a few things you should avoid and non-obvious best practices to use to make that ETL faster and more reliable. Assuming attendees have a basic level of familiarity with Kimball Data Warehousing methodology, this talk will explain how to accomplish Kimball style ETL using SQL Server Integration Services. We'll review the SCD Wizard and how it works for processing your dimension tables - what it's good for, what it's not, and what alternatives you have to it. We'll also examine fact table loading using a surrogate key replacement pipeline, especially using the Lookup component efficiently. Finally, we’ll look at specific and easy performance tweaks, techniques and best practices that apply directly to DW loads. That includes reviewing which Data Flow components to avoid and how to still get your work done without them, and tuning inserts and updates.

Ratings and Recommendations

Avg. Rating

Average based
on 1 rating

comments powered by Disqus