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.