Purge_Table operations taking long time.
Target table : 60 Billion records
Stage table : 800 Million records.
Every time we merge Stage to Target a lot of delete vectors are created.
So we purge the table before exiting out of the script.
Purge table takes long time to successfully execute and come out.
By that time next batch of record arrives and the earlier Purge_table operation is not completed, so the next merge fails with
timeout error Timed out T locking Table: Target_table. X held by [user:
is there a way to fasten the purge_table operation.
Please suggest a way to overcome this scenario.