Archives of the TeradataForum
Message Posted: Fri, 25 Jul 2002 @ 19:50:21 GMT
| Subj: | | Re: TPUMP-Multiple table insert/update |
| |
| From: | | Narayan Murthy K S |
I don't think that the MaxLoadTask Parameter is applicable to a TPUMP job.
Extract from the manuals and the online help : "The MaxLoadTasks field controls the combined number of FastLoad,MultiLoad, and
FastExport tasks allowed in the system."
TPUMP does not impose any limitation on the number of instances that can be run concurrently. This is advantage that TPUMP has
over Multiload, which(Mload) has a limitation of 15 concurrent load tasks(which is what the mailgram talks about) - which again could
be shared across Multiload,Fastload and Fastexport jobs.
| | 2. Single input file with a single LAYOUT having the data to load > multiple tables. | |
This is possible : Tpump allows upto 63 DML statements which includes INS,UPD,DEL. TPump allows multiple DML statements to be
applied to the same data record in two ways.First, if an APPLY clause refers to a label whose scope includes multiple DML statements,
each of these statements is applied to the same data record under the same condition specified in the clause. Second, if multiple
APPLY clauses are used, each can refer to the label of a different DML statement or group of statements. Each label's statements are
applied to the same data record under that condition specified in the respective clause. These features allow you to apply the same
data record to different tables under the same or differing conditions.
For more on the TPUMP usage checkout the TPUMP Reference manual at www.info.ncr.com
Narayan Murthy K S.
| 
