InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 18:51:37 GMT20http://www.teradata.com/teradataforum/Topic11456-1-1.aspxhi,you can specify the work and error tables using below format(eg. MLoad) in your load script :..........WORKTABLES Database.WT_ ERRORTABLES Database.ET_ Database.UV_ .............if you dont specify anything using the keywords WORKTABLES and/or ERRORTABLES, teradata aumatically creates these tables and maintains it.thxWed, 21 May 2008 16:12:56 GMTSNhttp://www.teradata.com/teradataforum/Topic11456-1-1.aspxHiSo I have to mention the wrk table names at the time of creation of the utility script ? What happens if I do not mention any table names?ThanksMon, 19 May 2008 15:00:02 GMTmaverickhttp://www.teradata.com/teradataforum/Topic11456-1-1.aspxhi,work tables are needed by the load utilities to log errors and assist load process. Just the work table name has to be supplied and the utility takes care of of the rest.thxFri, 16 May 2008 13:41:26 GMTSNhttp://www.teradata.com/teradataforum/Topic11456-1-1.aspxHiCan anyone explain what is a wrk table and what is its usage? Do we have to create it explicitly or does the loader utility creates it by default for each target table ? Can we use this table to track errors?ThanksThu, 15 May 2008 16:23:55 GMTmaverick