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!
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!)
ReplyDeleteCan you help please?
Chris Tayler
chris.tayler@kmpt.nhs.uk