• Probably won't work because what if your key's don't match? I would imagine they won't all be the same key, so you'll then end the time period for every row in your dimension and make all records not active?

    First you have to have a match on a key. At that point you can check to see if the other fields do not match.

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog