How can I use a different target database (not TdpId) than what I declare in WorkingDatabase? I want the log and error tables to go to a work database, but the target table is in a different database.
Work.ExampleTable_ET = error table in Work database
Person.ExampleTable = target table in Person database
When I try to set TargetTable='Person.ExampleTable' I get an error.
DEFINE JOB LOAD_JOB
DESCRIPTION 'Loading Data From Results Flat File to Work Table in Teradata'
APPLY ('DELETE FROM Person.ExampleTable;')
TO OPERATOR ($DDL);
STEP Load_Table (
APPLY $INSERT TO OPERATOR ($LOAD() [@LoadInstances])
SELECT * FROM OPERATOR ($FILE_READER() [@FileInstances]);
I was also hoping to get this answered. I hope it is possible. To the person posting, did anyone ever respond?
Provide a fully qualified tablename (including the database name) for the TargetTable attribute (and/or corresponding job variable).