Handling Late-Arriving Facts

Problem

An offline POS terminal uploads transactions that occurred last week. In your star schema database, the fact table references dimension values that might have changed since the transaction occurred. Write a query that outputs solution with the value: "Late-arriving facts are handled by looking up historical dimension keys matching the actual transaction timestamp, typically using SCD Type 2 tables."

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