ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 5. ETL – Delete VS Truncate

SSDB ETL - Delete vs Truncate

Advertisements
ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 3. ETL – Slowly Changing Dimension SCD Type 1

Tracking Changes Over Time Setup and SCD Type 1.

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 2. ETL – Incremental Loading process with Merge Statement

Incremental Loading with Merge.

Data Warehouse · ETL using SSDB · Microsoft Data Technology · Microsoft SSDB · Microsoft SSIS

SSDB – Part 4. ETL – Slowly Changing Dimension SCD Type 2 and 3

Extract Transform and Load using SQL server database stored procedure.

ETL using SSDB · Microsoft Data Technology · Microsoft SSDB

SSDB – Part 1. ETL – Flush and Fill Versus Incremental Loading

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