This is a good strategy if
there are clearly defined expected errors in external data, and if
they are likely to affect only a small subset of the data.
To detect and repair expected
import errors before bulk import:
||Define and create a reject table if necessary.
||Define an error import task importing records that have
expected errors into the reject table (use a WHERE clause to test
for the error).
||Define the main import task. This job can be based on the
assumption that the expected error(s) no longer exist(s) in the
Alternatively, you can append
the main import task to the error import task, and make it
conditional upon the error import no longer affecting any data.
||Run the error import task.
||Inspect the reject table. On the basis of this information, fix
the errors in the external file.
||If necessary, run the error import task again to test that the
error no longer occurs.
||Run the main import task.