Lab: Implement a slowly changing dimension in Redshift
- Learn how to create a type 2 dimension table by adding slowly changing tracking columns
- Dataset: customer table from the TPC-DS benchmark dataset
- Uses the best practices and anti-patterns
- Go over the extract, transform, and load (ETL) merge technique, demonstrating the SCD process