SCD1 not working correctly

Jul 7, 2013 at 9:03 PM
Hi there,

Great tool but I think there's something that doesn't work in your SCD1. All history should be updated whenever there's a change so I don't get why you look for records where the EffectiveDate is NOT NULL (in case there are SCD1 and SCD2 columns within the same table).

SCD1 -> Update ALL records
SCD2 -> Update records where EffectiveDate IS NULL (Create a new version).

Jul 20, 2013 at 4:41 AM
Hi Darsidious,

first of all thank you for using SCD Merge Wizard and for providing useful information.

Regarding behavior you noticed, if you check Microsoft's Slowly Changing Dimension component you may notice that way SCD Merge Wizard works now is exactly the same as Microsoft's SCD component. Of course, I am not saying that this is the best way.

Nevertheless, I believe that this could be included in a project as an option for user to choose:
  • update only current records, or
  • update current and outdated records
Once again thank you for noticing this - I will definitely add an option for both behaviors.

Jul 28, 2013 at 5:56 AM
Hi Darsidious,

there is new version of SCD Merge Wizard - version 4.0 where you can find this functionality implemented. Check Properties page.