Updated on 2024-12-13 GMT+08:00

Why Data Load Performance Decreases due to Bad Records?

Question

Why data load performance decreases due to bad records?

Answer

The loaded data contains Bad Records, and the value of BAD_RECORDS_LOGGER_ENABLE is true or BAD_RECORDS_ACTION is redirect.

Data load performance degrades due to additional I/O overhead caused by writing failure causes to the log file or redirecting Bad Records to the original CSV file.