Level 7 - ArchitectScenario-Based Questionsm4 dimensional performance models
Scenario: Late-Arriving Facts Handling
How do you handle late-arriving facts so dashboards stay fast and historically correct?
Schema Context
fact_orders(order_id, order_date_sk, amount, load_ts), dim_date(date_sk, full_date)