More About Denormalization

Use case: Validity period as a range

A variant of the historic table requirement is when our application needs to process the data even after its date of validity. When doing financial analysis or accounting, it’s crucial to relate an invoice in a foreign currency to the valid exchange rate at the time of the invoice rather than the most current value of the currency.