SSDB ETL - Delete vs Truncate
Tracking Changes Over Time Setup and SCD Type 1.
Incremental Loading with Merge.
Extract Transform and Load using SQL server database stored procedure.
Flush and Fill Verses Incremental Loading A great place to begin when designing an ETL process is to decide if you will use an incremental load versus the simpler flush and fill technique. With incremental loading, you insert, update, or delete data in destination tables that have changed in the source table on a row by… Continue reading SSDB – Part 1. ETL – Flush and Fill Versus Incremental Loading