Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  April 7, 2012 at 11:17 pm

  #256045

  When you load the Staging table for an Incremental Load is it not common practice to do a comparison with what is in the corresponding Data Warehouse Table to populate the Staging Table?

  Also is it not common practice to mark the record in Staging with an INSERT, UPDATE or DELETE Flag so that you know what to do with the record?

  Any ideas or suggestions would be greatly appreciated.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  April 7, 2012 at 11:22 pm

  #1470494

  I kept getting IE Errors and it did not apprear the my question was posted.

  Please do not reply to this post.

  Please reply to the following:

  http://www.sqlservercentral.com/Forums/Topic1279948-363-1.aspx

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/