Ingestion workflow - provide an option for "Dry run" simply for validation checks
This option can be helpful to alert the Data Loader of issues in input data, simply from integrity tests.
Then he/she can take corrective action up front and then attempt to actually load the large data set.