SNAPSHOT MAKER OF QVD

[abhaysingh]

Hi Guys,

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?

Pls suggest

Regards

Abhay

[arulsettu]

do you want to see the data in qvd?

[#3]

Hi,

Assuming you are using an incremental load it would be something like:

maxdate:

load max(date) as maxdate

from old.qvd;

let vMaxDate = peek('maxdate',-1,'maxdate');

Data:

load * from currentdatabase where date > vMaxDate;

Concatenate(Data)

load * from old.qvd;

Store Date into old.qvd;

Bit laborious but I haven't used incremental loads for a while.

Regards,

Pravesh

[abhaysingh]

No i am not using any incremental load till now

[#5]

Should work either way, even without an incremental load strategy actually.

[tyagishaila]

You can store qvd with variable name by this on daily basis you can Store QVD with different names.

[#7]

Yes, using a variable.

LET vMonthEnd = Date(FIELDVALUE('MONTH_END',1),'YYYYMMDD');

STORE LRA_Data into \\xx\yy\zz\LRA\abc_$(vMonthEndQVDName).qvd (qvd);

[#8]

Please mark a HELPFUL or CORRECT if it is what you looking for. Thanks

[abhaysingh]

Hi,

I dont have the date in my table ,

Load  Plant, MaterialGroup,Qty  from qvd

this is table i have .. dont have date in it..

pls suggest

[#10]

in that case use today() in the variable to datestamp