Incremental Load for Monthly Qvd

[Anonymous]

If my qvd are store on monthly basis i.e.  test_201602 ,test_201709.

How we can apply the incremental load on this data

[shraddha_g]

From your file format take date as

date(date#(right(Filename,len(Filename)-index(Filename,'_',1)),'YYYYMM')) as FileDate

If you have Incremental Script,

In your incremental script, use this Date from Previously stored Qvd, add 1 to it. Store it to the variable n then use that variable in Filename as test_$(vDate).qvd

[khalander]

I have done same task.

please go through the below thread

Incremental load by using qvd date