What are Slowly Changing Dimensions, and how do you handle them in ETL? Describe the different types and when you would use each.

Sample answer preview

Slowly Changing Dimensions refer to dimension table attributes that change over time in a data warehouse. The challenge is deciding how to handle these changes while maintaining historical accuracy for analysis.