Temporal joins

Not applicable

Temporal joins

What is the best way to join temporal and non-temporal tables together?

I have slowly changing dimensions type 2 that are all temporal (validtime) and facts (i.e. sales) that are normal tables.

Now I would like to join them all but not using AS OF. For examle:

I want to get Sales grouped by Item Class for last month. As Item Class can change during month I want aggregations to reflect this.

All solutions I've encountered so far are wasting Temporal benefits. I would appreciate some help here.