About the Talk
February 26, 2011 10:15 AM
Vancouver Marriott Pinnacle Downtown Hotel 1128 West Hastings Street Vancouver, British Columbia V6E 4R5 CanadaVancouver Marriott Pinnacle Downtown Hotel 1128 West Hastings Street Vancouver, British Columbia V6E 4R5 Canada
Microsoft designed Integration Services with ETL processing for Data Warehouses 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. This session 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 - and what alternatives you have to it. We'll also examine fact table loading using a surrogate key replacement pipeline. Finally, we’ll look at specific and easy performance tweaks, techniques and best practices that apply directly to DW loads.