I have a master file of data which I want to read in and save out as a QVD. From then on I want to read in that QVD, delete old records I don't want and append new ones, then overwrite that existing QVD which another QV document reads in to use in the front-end.
This works fine. My worry is to productionise this there is an issue around what would happen if 6 weeks down the line someone (probably me) does a debug load of 1000 rows (for example) which overwrites the rolling master QVD with this data. This leaves you up the proverbial creek.
I wondered if anyone had automated a system that works around this problem of overwriting your master each week?
