Level 7 - ArchitectScenario-Based Questionsm4 dimensional performance models
Scenario: SCD2 Dimension Join Performance
Your sales fact joins to customer_dim (SCD2) and query latency is high. Propose model/query strategy to keep historical correctness with better performance.
Schema Context
fact_sales(order_id, customer_sk, date_sk, amount), dim_customer(customer_sk, customer_id, valid_from, valid_to, current_flag)