Updates not working on Slowly Changing Dem.

  • just FYI for anyone......I added a sort operator and sorted on the Key before it went into the SCD...its to have fixed it.

    My guess was in the backgroup it was doing a hash match join and for some reason it was failing....so I figured it if I sorted the key then the engine would have an easier time joining the table...

    anyhow it seemed to work!

Viewing post 1 (of 2 total)

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