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

    IntervalMatch

    Creating a Date Interval from a Single Date

    Creating Reference Dates for Intervals

    Slowly Changing Dimensions

     

    HIC