Thanks a lot for your suggestion .

Can  you please  elaborate more on this "If the updates/deletes are sporadic, select the updated date into a new column store table, then swap the old table with the new one. "  I need to run this update query every day.
This is my update query, you can  refer my post for complete query.

  update c
  set c.Associate_Profile_key=AP.Associate_key,
  c.Record_update_date=sysdatetime(),
  c.Record_Updated_By=suser_name()
  from cte as c
  join dimentions as AP on c.Associateid=AP.Associateid
  and c.[Associate_Profile_key] <> AP.Associate_key;