Post reply

Implementing SCD type 1 & 2 using DTS

  • July 22, 2003 at 1:00 am

    #106916

    Hi

    How to implement SCD type 1 or 2 using DTS? Already implemented the concept using T-SQLs and calling them using Execute SQL Task. Now i want to implement this without using T-SQLs and DDQ.

  • July 25, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 25, 2003 at 4:18 pm

    #467157

    It seems like even in a DTS you're going to end up using T-SQL (Execute SQL Task).

    I'm curious, why are you using DTS and not a sproc or a job (or possibly a trigger with SCD 2)? DTS seems like the slower way to handle this.

    For the record, I should note that SCD is not something I'm familiar with so sorry if I'm missing something obvious.

    Everett



    Everett Wilson
    ewilson10@yahoo.com

  • July 28, 2003 at 9:57 pm

    #467389

    Microsoft have an article on how they use DTS with type 1 and type 2 SCD (Slowly Changing Dimensions):

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

    I don't think you will be able to avoid using T-SQL. It would be nice if microsoft created task to handle dimension and fact table builds. I have had some exposure to the Cognos and Sagent ETL tool and they both have objects that will handle the SCD and linking the keys back to the fact table in the staging environment.

    Cheers

    Matt

Viewing 4 posts - 1 through 3 (of 3 total)

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