The Teradata FastLoad completion message for the END LOADING command depends on whether the job includes a RECORD command.
The following table describes the possible RECORD command Completion messages.
Job | Teradata FastLoad Response Layout |
---|---|
If the Job includes a RECORD command |
Total Records Read = 500 - skipped by RECORD command = 50 - sent to the RDBMS = 450 Total Error Table 1 = 25 Total Error Table 2 = 0 Total Inserts Applied = 425 Total Duplicate Rows = 0 |
If the Job does not include a RECORD command |
Total Records Read = 500 Total Error Table 1 = 25 Total Error Table 2 = 0 Total Inserts Applied = 475 Total Duplicate Rows = 0 |