Post reply

SCD Type 3 implmentation using SCD transformation in SSIS

  • August 22, 2014 at 4:11 am

    #298697

    Hi,

    Can we implement SCD Type 4 using SlowlyChanging Dimension transformation in integration services.

    If yes,can you please explain how??

    SCD Type 4 – This is not a frequently used SCD type as this has limited history to maintain and requires changes to the table. In this SCD type, additional columns are added in the table to keep the latest values whereas the older existing columns will have older values.

    Thanks inadvance..

  • August 22, 2014 at 4:22 am

    #1740134

    No, the SCD transformation in SSIS only handles Type 1 and Type 2 SCDs...but I wouldn't use it at all because it performs poorly in terms of speed. Better to 'roll your own' using, for example, the T-SQL MERGE statement. There are 3rd party components available that perform orders of magnitude better, but none of them are free AFAIK.

    Regards

    Lempster

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply