IntervalMatch and Slowly Changing Dimensions

    • 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 this Technical Brief.


    Thank you Barry for good discussions.


    See also the following blog posts


    Creating a Date Interval from a Single Date

    Creating Reference Dates for Intervals

    Slowly Changing Dimensions