I need to be sure how the failure can be handled. Failure types: lose of the connection, aborted upload, RDBMS failure, no more room in the target, etc
Question No 1 How to I cancel and access the data that it loaded into target table ? How to release the table ? I am getting 2652 error
Question No 2
How can I restart tpt script which has export - load operator? The load operator creates UV, ER and log table. If i try to restart the script it says that it is under load process even if i cancelled the job.
I need to be able to restart the load process from the checkpoints and not from the begining. I know it is a solution to drop the error and log tables and restart it, but i wouldn't do that because the size of the table is huge. How can I restart it?