Help with Teradata Enterprise stage

[arjun_004]

For all insert jobs, the Teradata Enterprise stage needs "Create table" rights to the database where the target table is present. This is because it creates intermediate work tables to load the data and currently we do not have the "create table" rights to the target DB. Is there any parameter that exists which can point to a different database for creating work tables in Teradata Enterprise stage? We are currently not using Mload/Tpump stage where it is possible to specify the work database.

[keshav0307]

yes, in the addtional connection option , workdb=<the other database name>