Running Teradata Parallel Transporter :  Load Operator and ODBC Operator Version 15.10.00.01
I'm attempting to load several tables from an Oracle Database with ODBC and Load Operators (Streaming data with "Job is running in Buffer Mode").
Several tables work great without specifying a BufferSize for the Load Operator:

Hi All
I want to know one thing. I submit one TPT Load job. If the job fails the target table will be locked (similar to fastload).
Both are valid, but what is the better remedy?
use Standalone TPT Load job to apply and release the lock 
or
using ddl drop and recreate the table every time.
 
Thanks