Incremental Load, data chuncked by month

[#1]

Hi,

I would like know how to perform an incremental load where in it will produce a qvd for the current month and the succeeding month?

Lets say this month, I perform an incremental load, only the data for this month will be stored in the January.qvd and if current month = February, data for feb are only sotred in the qvd.

Another question, How is the maintainability for this kind of setup?

Many Thanks!

[#2]

up

[#3]

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(monthstart(today()))# ;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT Exists(PrimaryKey);

STORE QV_Table INTO File.QVD;

by implementing the above code it will load only the data from the start of the current month till the max date.

[#4]

I have a dynamic qvd filename that will change when the current month changes, for example current month = January2012 and then tomorrow current month = February2012.

How can I assure that the data inside January2012.qvd are only for january and are complete and what if the new data are entered on February but there are new data for January.