Incremental Load

[MK_QSL]

What is wrong in script from enclosed file?

When I load first script and create a QVD, it is giving me only 2013 until september end data.

But after doing incremental load, I got 2010, 2011,2012 data also.

[ronaldocarrijo]

Do this, and tell me if it returns some data:

WHERE DECDDT >= '01-Jan-2013' and RIGHT (PNO, 1) <> '4' and RIGHT (PNO, 1) <> '3'

[MK_QSL]

any answer on this?