DSXchange

Hello,

We have been running our Datastage jobs for a while now with Teradata as the target database.

On a routine check... we saw that the work database on Teradata is growing in size.

When looked we have a lot of tables starting with ORCH_WORK_ followed by some numbers.

Does anyone know what these are and why they are left behind?

Thanks

The ORCH_WORK_XXXX table will not be dropped if the job abort.
similarly ORCH_ERR_XXXX will not be dropped if there are any error records.

ORCH_WRK_XXXX tables are working tables for Teradata Enterprise stage it use this table to load the load using fastload and then do insert select from this table to the final table, if the job aborts due to any reason these tables will not drop.

Makes sense. Thank you very much.