• What techniques are there to match a number with an interval?
• How does the IntervalMatch prefix work?
• Should I join the interval match table with the event table?
• How do I generate an interval from a single change date?
• What is a Slowly Changing Dimension?
• How do I model a multi-level Slowly Changing Dimension?

These questions and others are answered in the attached Technical Brief.

See also the following blog posts:

• IntervalMatch
• Creating a Date Interval from a Single Date
• Creating Reference Dates for Intervals
• Slowly Changing Dimensions