Pages

Friday, April 2, 2010

SQLSaturday #41 - Atlanta - Slowly Changing Dimensions

I'd love to be there - but it's really far away from where I live.  A couple months ago though, I started talking to Julie Smith (blog) as she had a question or two about the Kimball Method Slowly Changing Dimension component.  Turns out that Julie is going to do a session at the Atlanta SQLSaturday on processing dimensions using a few different methods - with the KSCD being one of them.  (I still can't believe that Julie asked permission to do that talk - I'm quite flattered and ecstatic.)  Here's the abstract:
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!
I'd encourage anyone who reads my drivel, and lives within three hours of "hotlanta" to take in Julie's session.  I'm certain that Julie will do a fantastic job of highlighting the strengths and weaknesses of each method - reading her blog and emails on the subject leave no doubt she's very sharp.
It's the kind of session I'd considered doing myself - and in fact recently submitted to the closest SQLSaturday I might be able to get to (in Portland).  Of course, I'll have to work very hard at being unbiased.  If I can possibly get Julie's permission ;) I'm sure to lift a few of the more objective ideas from her presentation to even out my own.
Good luck, Julie!

1 comment:

  1. I'm trying to use the Codeples Slowly Changing Dimension component in SSIS 2008, and can't find any guidance about assigning Param values (or any documentation at all for that matter!)

    Can you help please?

    Chris Tayler

    chris.tayler@kmpt.nhs.uk

    ReplyDelete