March 19, 2019 at 8:59 pm
Slowly Changing Dimension Wizard
Has it improved in newer versions of SSIS and Visual Studio ?
I'm finding it a bit tedious ... but I am working with a somewhat unwieldy table with ~400 columns ..
The step where "Select a change type for slowly changing dimension columns:" ..
I am wishing for:
1) an automatic "add all columns" button .. instead of having to click empty cell after empty cell ... and scrolling down when screen full to allow 2 more empty cells to become columns
2) default of Change Type to be "Changing attribute" rather than "Fixed attribute"
Am assuming that a newer version of SSIS will have fixed this. I am on Visual Studio 2010 .. and SQL*Server 2012 at work at moment ..
I have newer software on home notebook ..
I will check and see if Microsoft have improved this.
Do other people use this "Slowly Changing Dimension" component lots ?
It seems to cater for the insert / update case ... not sure about delete case ... for full data sync ..?
What would people use instead of this ?
I could use a conditional split component .. but the configuration of conditions for ~400 columns seemed daunting to say the least ..
March 21, 2019 at 6:35 am
It hasn't really improved, and I'd recommend that you don't use that component at all. Others in the community have developed other design patterns for slowly changing dimensions that you could use, but to be honest I use stored procedures to load dimensions. In any event, moving away from that SSIS component will be a good choice.
March 21, 2019 at 6:26 pm
Martin Schoombee - Thursday, March 21, 2019 6:35 AMIt hasn't really improved, and I'd recommend that you don't use that component at all. Others in the community have developed other design patterns for slowly changing dimensions that you could use, but to be honest I use stored procedures to load dimensions. In any event, moving away from that SSIS component will be a good choice.
Thanks, appreciate comment, ... fair enough ..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply