Some tables must be created by the user before the job begins and some are created during the execution of a job. A target table must exist on the Teradata Database when the Load operator job is executed.
If you have not specified error tables (specifying them is optional), the Load operator automatically creates names of the error tables as follows:
- The first error table is ttname__ET
- The second error table is ttname_UV
where ttname is the name of the corresponding target table.
For example, if the following is specified when no error table specifications exist,
VARCHAR TargetTable = 'ttname’
the Load operator creates the following error tables: