Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 25 Jul 2002 @ 19:50:21 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020