The following table describes the things to consider when using the BEGIN MLOAD and BEGIN DELETE MLOAD commands.
| Topic | Usage Notes |
|---|---|
| Database and Table Name Specifications | If the work table or error table names are not specified, Teradata MultiLoad creates them using the target table or view names with a three-character prefix of WT_, ET_, or UV_, as in:
|
| Dropping Teradata MultiLoad Work and Error Tables | In the case of a paused Teradata MultiLoad job, do not drop the work tables or the error tables until Teradata MultiLoad completes the import or delete task. For more information, see Usage Notes. |
| Error Table Column Names Not Allowed in Target Tables | Teradata MultiLoad posts the faulty client record information. Teradata MultiLoad also posts information that identifies the record and the type of error to the UV_ and ET_ error tables. This additional information is provided in eight columns that precede the faulty records from the client system. To maintain the integrity of the Teradata MultiLoad error table information, target tables must not use any of the eight error table column names:
|
| Session Configurations | There is no general method to determine the optimal number of sessions, because this number is dependent on several factors, including, but not limited to:
Using too few sessions is likely to unnecessarily limit throughput. On the other hand, using too many sessions can increase session management overhead (and also reduce the number of sessions available to any other applications) and may, in some circumstances, degrade throughput. Regardless of the size of the database system configuration, for large repetitive production applications, it will usually be appropriate to experiment with several different session configurations to determine the best trade-off between resource utilization and throughput performance. For larger database system configurations, it is appropriate to establish an installation default for the maximum number of sessions that is less than one session per AMP. This can be done either with the installation configuration file (see Teradata MultiLoad Command Conventions) or with a standard run-time parameter (see Teradata MultiLoad Command Conventions). An installation default for number of sessions, if specified in the configuration file, can be overridden in individual Teradata MultiLoad scripts, when necessary. |
| Unspecified Target Objects | During processing after the BEGIN MLOAD command, Teradata MultiLoad terminates with an error message if it encounters a reference to:
|
| Views as Import Target Objects | To be a valid target object in a Teradata MultiLoad import task, a view must:
Also, a view must not:
|