Kimbal SCD1 changes create a new row

  • I'm new to this, so please excuse me if the answer is obvious.

    Using the Kimball SCD, new source rows get created correctly in the destination, but changed source rows are creating new rows in the destination, with the same Business key and Surrogate key as existing rows.

    It's probably something stupid that I have missed, but any pointers as to why I'm getting new rows, instead of updates to the existing rows, for Type 1 changes, would be much appreciated.


    Tim

  • It's quite likely you just have the outputs hooked up to the wrong kind of persistence component. For example, you've used a Destination instead of an OLE DB Command component. My mistake on the 'demo' video that assumes too much. Try looking over the new set of videos on the site to get an idea of how to hook it up.

    Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
    My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components

  • Todd,

    Thank you, you were spot on, I had Destination for the SCD1 output instead of a OLE DB component. Reviewing the video made it obvious.

    Thanks


    Tim

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

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