Conditional Delete for Incremental Load

[#1]

Hello all,

Is it possible to pass a month parameter for the Delete task in Incremental Load?

In other words, My delete task in Incremental load should look up for only past 6 months data and delete the files which are already deleted from datasource.

Any Help would be appreciated.

Best Regards,

Susvith

[luis_pimentel]

Hi,

Did you check out this document  Incremental Load.docx about how to implement Incremental Loads?

Hope that helps!

-Luis.

[#3]

Thanks for your reply Luis

I am done with Incremental load (Insert/Update/Delete). Now I got scenario , that while deleting its should check only last 6 months data instead of whole data.

Is it something possible??

Thanks in advance

[jonathandienst]

Hi

You cannot delete loaded data. For this scenario,  just load data that is less than 6 months when loading from the previously extracted data from QVD(s).

     FactTable:

     LOAD *

     From MyData.qvd

     Where TransactionDate > AddMonths(Today(), -6);

     Concatenate (FactTable)

     <load new data from original source>

HTH

Jonathan

[#5]

Thanks for your reply jonathan