Any plan to add multi-day batch handling or full datetime effective dates?

Topics: Possible Bugs/Missing Features?
Sep 7, 2010 at 5:22 PM

I am recieveing multiple updates per day so I wanted my SCD to be date and time not just batch per day.

I have done this with some additional sql work to further vet the "New SCD2" data stream to confirm with the current day entries into the dimention table. Once this is completed I insert the records with no effective start date. Taking the "Expired SCD2" datastream I then drop entries that were removed from "New SCD2" and update the startdate of the "New SCD2" entry with getdate() then update the end date of the "Expired SCD2" with the startdate - 1 second.

I wanted to check here if there were any plans for this in future releases.


Sep 10, 2010 at 11:32 PM

If you're interested in multiple intra-day update capability, you should try the alpha of v1.6, or just wait till I get around to polishing it up.