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.
RSS - Posts
Be the first to comment.