how to implement incremental load with last modified date in loop?

[madhubabum]

Hi Experts,

I am having the following updated data QVD's.

Name              Last Updated on

Sales1.qvd     Dec-15-2015

Sales2.qvd     Dec-11-2015

Sales3.qvd     Dec-20-2015

Here i want to implement incremental load..How we can implement ? (Please help to write script)

Note :Loading Order

Sales2.qvd

Sales1.qvd

Sales3.qvd

Regards

Madhu

[jagan]

Hi,

If you are loading from QVDs I think there will be no change in the loading time, both Incremental and Normal load time is almost same.  I think implementing the Incremental load makes script more complex here, specially it is used to load from database.

Regards,

Jagan.

[madhubabum]

Hi jagan mohan rao,

Thanks for your reply

No, these files are having different time stamp

Name                                                    Last Updated on

Sales1.qvd(Oct-19-2015 06:12:30)      Dec-15-2015

Sales2.qvd (Nov-10-2015 11:10:45)     Dec-11-2015

Sales3.qvd (Dec-12-2015 10:23:25)    Dec-20-2015

[Anonymous]

may be Filetime() & QVDCreateTime() help you?

1) Load Sales QVds one by one

2) Store the Modified time of each with above functions

3) Then Compare stored time with each other qvds time

4) Finally call the Qvds with max timestamp with incremwntal load?