title: Employee Dimension Truncated everyday in Datawarehouse
body: <p>I am developing a new data warehouse and my source tables  for the employee dimension gets truncated every day and reloaded with all history and updates,deletes and new inserts.</p>
  
  <p>The columns which tracks these changes are effective date &amp; effective sequence.We also have a audit table which helps us determine which records are updated,inserted and deleted every day by comparing table from today &amp; previous day.</p>
  
  <p>My question is to how can I do a incremental load on the table in my staging layer so the surrogate key which is a identity columns remains same.If I do a truncate on my final dimension then I get new surrogate key each time I truncate  and hence it mess up my fact table.</p>