Forum Discussion
Incremental loading rolling 24 hours on database update time
Hi, is it possible to keep data for a rolling 24 hours and load new data every two hours (as the relevent old data is removed from the service)? One of our API's makes a call to one of our intern...
GilbertQ is it possible to call on a variable storing LastRunTime? It then can be store at place separately, which act as a data filter for next incremental update.
Hi there,
Yes you could store the LastRunTime as a variable which could be the MAX dateTime from your dataset. So you know where to start next time?
Yes you could store the LastRunTime as a variable which could be the MAX dateTime from your dataset. So you know where to start next time?