Is there any way I can forcefully/manually stop/fail TPT while it is loading (while TPT is in application phase) the staging tables so that the table being loaded is locked and there is no way to access it.
I need to perform some tests on TPT locked tables
How do you invoke TPT?
Linux shell? -> control C
Usually ETL tools also allow to kill current processes.