Thanks for the reply but unfortunately I was told that I can't expect any modifications from the CRM team in the near future and I have to draw up a...

Ok a problem has come up with the sliding window strategy.  Say we have a fact table and a dimension table:  FactEntry and DimProduct.  If I were to consider all...

Thank you very much for your help and responses for this tough requirement.  After many emails sent back and forth the product owner agreed that a sliding window solution is...