incremental load custom where clause

[domski74]

In order to always retain only a specific period (e.g. 2 years) worth of data in the imcremental qvd, I'd like to suggest that you have the ability to add a from date to the qvc incremental load so the qvd concatenate adds a where clause. Added as an optional parameter in incrementalstore?

Thanks

[MattFryer]

Hi,
Interesting idea! Having taken a look I can't see any obvious work around but Rob knows the incremental routines better than myself so he might be able to suggest one. We could possibly use the existing Qvc.Loader.v.BaseValue variable to implement this which is normally only used when performing the first reload or when a full reload has been requested.

Regards
Matt

[MrCode9]

Hi Matt, to cut off the "n" days in QVD, just create temporary table that had all date values with in "n" range and Inner join with your QVD table. The down side is we need to add new field "date" if we don't have a date field (timestamp field).