SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2011

Changes to the SSIS Slowly Changing Dimension Component

Probably not the kind of change you're expecting.  I've recently been contacted by the Kimball Group, and they've asked me to stop using the word "Kimball" to identify the component.  They have every right to make sure nobody is confused about who they are and what they do, or…

Read more

20 comments, 2,985 reads

Posted in Todd McDermid's Blog on 25 February 2011

How To: Load Dimension Tables with Integration Services - Introduction

When I first started down the business intelligence and data warehousing road, I needed to learn the foundations of dimensional design.  Ralph Kimball's methods seemed appropriate at the time, and they still are for me.  The next step was learning how to make Microsoft's BI tool stack follow that methodology,…

Read more

0 comments, 1,121 reads

Posted in Todd McDermid's Blog on 16 February 2011