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.
| 
