We're creating a new version of a 20 years old database, in which we used to keep version history by creating new rows in each table (SCD Type 2). SCD Type 2 is not that hard when you need to keep ...
I'm trying to solve the following scenario: I have a "Zone" dimension, a "Tile" dimension and a "Position" facttable. Within the facttable the duration of a hit on a tile is saved. The Many to Many ...