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

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 try to capitalize unfairly on their reputation.  I never intended to do anything of the sort, and certainly hope I've never given that impression.  Work is (slowly) underway to strip it out of the project materials on CodePlex.
Lemonade, Anyone?
So if I can't identify the component by the name of the methodology it follows... I've got to find something else for it's title - because "SCD component" is just boring, and will easily be confused by the component of the same name (but definitely inferior capability IMO) included within SQL Server Integration Services.
I could come up with a label, but it would probably be really lame.  Anything I can think of to tack on to "SCD Component" seems trite and overused in the world of 3rd party objects.  Your typical adjectives of "ultimate", "fast", "improved", "enhanced" don't seem to be able to capture what I'm looking for.
I Need Your Help
This component turned into a real community experience for me - 50,000 site visits,13,000 downloads, 600 discussion posts, and 100 bug reports and suggestions.  Best of all (for me) were 4 four-star and 10 five-star reviews (nothing lower) and the expressions of support.
So that's why I'm turning to you - the people who know what this component does better than anyone!  I'd like to run a little contest to come up with a new name for the project - something that speaks to the impact that it has for you in processing incremental dimension loads in SSIS.
Think Out of the Box
Don't restrict yourselves to looking through the thesaurus to find an adjective to tack on to "SCD Component" like I did.  Think unique.  A descriptor that's funny, insightful, or just plain accurate will do - but not something you'd hear everyday.  Send me your idea for the full name of the component, as well as something shorter if you get out of breath saying the full name.  (An obvious nickname would be the acronym... but you can do better, right?) 
Leave your ideas (and lobby for your favourites) in the comments, send an email to toddmcdermid at live.ca, tweet to @Todd_McDermid, or tell me in-person at SQL Saturday #65.
The Incentive
Seriously - you need an incentive other than contributing to the community?  Of course you don't - but I have one for you anyway.  The winner - chosen at my sole discretion - will get a boxed Windows 7 Ultimate x64.  You'll probably have to patch it to SP1 by yourself... but you guys develop SSIS ETL packages, so I know you're used to a little manual hackery.  (I may also have a little something for the funniest entry - I'm talkin' shooting-milk-out-the-nose funny...)
The Time Limit
All good things must come to an end - and this contest will too.  You've got one week - until midnight Pacific Time on Friday, March 4th to send me the moniker that should emblazon the best SCD option for SSIS.  Stay tuned for the results!


Posted by knight_devin@hotmail.com on 28 February 2011

Todd, you've done a great job on the tool.  Look forward to the changes.  I'll be thinking of a name for you!

Posted by andre.vella on 3 March 2011

**The incredible SCD** .. just like Hulk! I think if you remove the 'SCD' term from the name you'd be sort of missing on the actual purpose so I'm not sure if you can do without a "typical adjective". Maybe 'generic' or the as you suggested 'enhanced' could fit. Anyway, good luck with finding a cool name and all the rest. Excellent job for the tool ... i've found it extremely useful.  

Posted by Claus on 3 March 2011

Well - based on your name - we can make a "phonetic" variant calling it:

"OddMakeDimIt Component" ;)

- "Oh, so you're also using the "odd make dim it" component?"

Posted by dave on 3 March 2011

Hopefully the Kimball group can't moan about this, but I chucked 'Kimball' into an anagram engine and amongst others got 'Lab Milk', which is certainly quirky and unique :-)

Great component by the way, be nice if MS actually incorporated your work as a standard component!

Keep it up and ps - thanks for the help when I was getting started with it.

Posted by James Zimmerman on 3 March 2011

MMSCD - McDermid Method Slowly Changing Dimension

Posted by mtassin on 3 March 2011

Glass Slowly Changing Dimension Component?  (fwiw, Kimball used to be a brand of glass before Owens bought them).

Slowly Transforming Dimension Component

The Method That Shall Not Be Named Slowly Changing Dimension Component

Posted by mtassin on 3 March 2011

I threw that word that can't be used into an acronymn generator and got this.  








while you can't use KIMBALL, nothing says you can't use K.I.M.B.A.L.L. right?

Posted by jyates on 3 March 2011

Based on the image you included with the blog, I think you already have your name: Chameleon.  It changes when it wants to, just like some dimensions.

Posted by sharath.chalamgari on 3 March 2011

How about using the name 'Chameleon - SCD'.

The Chameleon is a type of Reptile where it will Slowly changes it's color.

Posted by DEK46656 on 3 March 2011

Call it what it is: T2SCD Component

Posted by Franky Leeuwerck on 3 March 2011

How about  ... the Slowly Changing Demon ?

Demon is some fusion of the words 'dimension'  and 'component'.

It refers to a component

- that is powerful;

- has a lot of gadgets in its trickbox;

- and can be mysterious for those who do not understand it all the way.

Posted by Kenneth Wymore on 3 March 2011

"The not-MS SCD Component" or maybe "SCD Upsert Task" since it does a insert or update based on changes.

Posted by cm5304 on 3 March 2011

"Fugitive" (ya know, Richard Kimball...)

Posted by smonk on 3 March 2011

Slow Leak

Posted by BrianAltmann on 3 March 2011

How about "Fast SlowDims"?

Posted by samarjot on 3 March 2011

"Dimension Shifter"

"Dim Shifter"

"Dim Shift"

you know like "Shape Shifter" ;)

Posted by austin.craig on 3 March 2011

McDermid's Type 2 SlowDim Manager

Posted by Patrick Dadey on 7 March 2011


Posted by nahk.fussuy on 8 March 2011

Late I know, but what about something simple

Advanced Dimension Processing

ADP for short.

describes what it does in a nice succinct manner!

Posted by Sergio on 16 March 2011


Leave a Comment

Please register or log in to leave a comment.