SCD Type 2 Filter

Problem

Your dimension table tracks historical changes using Slowly Changing Dimensions (SCD Type 2). It has start_date, end_date, and is_current columns. An analyst wants to see only the currently active state of each record. Write a query that outputs concept with the value: "SCD Type 2 tracks historical data by creating multiple records for a given natural key, with effective dates indicating which record is active."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution