Hello
I'm building a datawarehouse with all the usual facts and dimensions
It will flush (truncate) and rebuild on a monthly basis
Users have the need to not only view the data now but also view it historically i.e. what it was a point in time
My initial thought was to use time travel functionality but, am I right in saying that that's the wrong approach here, and we should really archive or apply a date filter to the data?

So, an alternate archiving strategy would be better?

Thanks