(UPDATE 2010-01-27: Version 1.5 has been released)
It is a good day - I've finally put the pieces together to update the Kimball Method SCD project on CodePlex. Version 1.4 is available, and I've been quite pleased with the improvements I've made, as I've been using it for the past month or so, tweaking as I went. If it's not a viable alternative for the SCD Wizard, I'd like to know why.
In addition to featuring an installer and Inferred member support, the new release contains a sample package for comparing the SCD Wizard (the component included in SSIS) to the Kimball SCD component. Making that package almost drove me insane as I had to deal with the SCD Wizard (again). My #1 gripe (refreshed) about the Wizard is that any little change to how I want the SCD handled results in it recreating itself (and all it's little "helper" components), disconnecting it from the rest of the flow, and basically causing carnage in my package.
The end result, however, is that the package shows (in my environment) that I can definitely claim a 100x speed improvement over the SCD Wizard. The primary reason for this is that this component doesn't do lookups to the Dimension table, it streams them in. If you're as frustrated as I was with the SCD Wizard, you owe it to yourself to try this out.
Full details at the Kimball Method SCD project on CodePlex. I've currently got it labeled as "beta" - so I'd appreciate a little feedback in order to push it to "stable" status. Let me know how it goes for you.
No comments:
Post a Comment