I have a table in which as on data is coming.. i want to see the data in backdate as well for that qvd data, for that cant i make snapshot of the data on daily basis?
Assuming you are using an incremental load it would be something like:
load max(date) as maxdate
let vMaxDate = peek('maxdate',-1,'maxdate');
load * from currentdatabase where date > vMaxDate;
load * from old.qvd;
Store Date into old.qvd;
Bit laborious but I haven't used incremental loads for a while.