Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
My goad is to load data everyday and keep log of it. If data was missed for particular day then load that day's data one day at a time to catch up.
How can i accomplish this.
My date variable is in format: YYYYMMDD
thanks
I have a qvd that has date for which data is already loaded.
LoadLogFile.qvd
20160801
20160802
20160803
20160804
StopDate=1 day minues today.
I need to load the data 1 day at a time (via for loop) for only dates that are not in log file and make sure it does not exceed Stop Date.
How can we achive the above.
LOAD
*
FROM 'sample data '
where date = $(Missingdate);
try this way on incremental load.