How about taking snapshots of the table into another table and flagging the records that get deleted via a Merge statement?

I'm not sure how often you would need to take...

Its an historical leftover from the company buying other companies, as a result there is a whole mismash of different warehouses and reporting tools all over the place.

Qlikview is also...

Actually in this instance SSAS is being used. A view is used to pivot the data back into the traditional structure that the cube is built on.

The original concept for...

OK thanks for that, unfortunately it's not my call and this design has been pushed forward as the way all new warehouses should be built going forward.

I'll have to see...