We have a daily scheduled data extractor to extract data from oracle database with incremental script ( below script), when we cross verified the data after some point of time let’s say 1 month we found that some data is missing it’s not up to date. please check the below script and advise...
// Loading AR Customer Sites SETvQvdFile='$(vFolderSourceData)CustomerMaster.qvd';
From your script I would assume that the data gets updated daily and is unique by day, meaning that once the database is updated for a given day, the data for that day is never updated. Is that the case?
I ask because we saw issues with this type of date-driven incremental loading because the database was updating older records (than the ones that were updated since our last reload). Records were being modified, reinstated, or removed.