I am trying to extract a table from our data warehouse with approx. 10 million records. It keeps timing out, so the DB team have suggested pulling the data in chucks instead of doing 1 single load.
Can anyone help in what I need to do to write a loop around my table load please?
The loop will just need to be on the number of records not on a date/month/year or any other field.
so i would extract the first 100,000 records, then loop to the start and extract records 100,001 to 200,001 etc, until all records have been extracted.
