Just to answer the question in relation to indexes & constraints on the fact table. Currently history is being tracked in the fact table using the SCD Type2 approach but...
First of all thanks for your input much appreciated. The trigger sounds like an interesting approach although I have heard that they are not good performance wise (I am...