How to make the date field not to change during reload in case of incremental load?

[nishanthi_8]

I have a table without last update which is a date field. And I need to do incremental load so i just created

                                today() as last_update as a field name.

And when i want to do incremental load like insert.. there is also a need to reload the table to reflect changes. In that case my last_update field will have the latest update date. So how to overcome it? I read some posts that incremental load on qvw only and so on.... where I couldnt understand the logic

[avinashelite]

try like this :

create 2 fields both with the today() as the value  and  store one field in the QVD as updated date . so that on every reload the date is appended with the data .. and while reloading use another field and compare it with the previously store column in the QVD ... this help you to load the data