Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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?