SQL Data Analyst — Medium
Key points
- SCD Type 2 maintains historical data by adding new rows
- The old row is marked as inactive to differentiate between versions
- Date range or flag is used to indicate the validity period of each version
Ready to go further?
Related questions