Posted by on November 26, 2013

Amateur loads of version rows, slowly changing dimension (SCD) type 2, loop through the incoming data one record at a time, like the SCD transform in Microsoft’s SSIS. This works, but the performance is awful.

If you already have Change Data Capture (CDC) records you’re well on the path to success.

Read the rest on the Optimal BI blog.

Posted in: Technical


Be the first to comment.

Leave a Reply