Archives of the TeradataForum
Message Posted: Fri, 25 Jul 2002 @ 19:50:21 GMT
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.
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|