While loading data from a flat file, we need to keep a pointer in the file, in case our process of loading the data fails, we need to re-start it from where it stops, and not start from the beginning. Is there a way we can do this?
Printable View
While loading data from a flat file, we need to keep a pointer in the file, in case our process of loading the data fails, we need to re-start it from where it stops, and not start from the beginning. Is there a way we can do this?
You could use SKIP. Then determine from your log file how many records were read and how many were skipped, and next time skip the sum of the two.
d.