Hi,
I have two tables with property information. Both tables have effective dating (from and to date). They are related through a property dimension table (lookup table).
The first table (PropertyFact) stores the size of the properties and the occupied space. A new record is added when the...