About the Presentation
Slowly Changing Dimensions--Done Well.
This session will address the different ways to handle slowly changing dimensions with SSIS. I'll cover the native SCD Component, the SQL Merge Statement , and the new Codeplex Kimball Slowly Changing Dimension Component. The goal is to show how to incorporate auditing, deal with Type 1 and Type 2 attributes, and most importantly, how to get it done QUICKLY!
Session Level: Beginner
Julie Smith
Julie Smith has spent the last 10 years moving data using varied tools such as MS Access, MySQL, and SQL Server 2000-2008. She is an MCP in SQL Server 2000: Implementing Database Design. She currently works at GA Communications as its first and only DBA, wearing many hats. Prior to GA Communications she worked as a database developer at The Network Inc. She is very simple woman with warm fuzzy secret heart.
Contact URL:
http://datachix.com