IntervalMatch function is used to match a single value in a table to an interval or range of values in another table. This scenario occurs in real time when you are trying to match a date in one table, which falls between two dates in another table. Another example will be matching the number of shifts falling in a time period of, say, eight hours.
IntervalMatch function is also useful in handling slowly changing dimensions (SCD), specifically Type 2.
Slowly changing dimension Type 2 is used to track the historical information of the data. For example, see the following employee records:
Employees with IDs 275 and ...