Archives of the TeradataForum

Message Posted: Thu, 03 Sep 2009 @ 08:08:13 GMT

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

Tpump normally create macros for the operation which you are performing, Before starting any data transactions say insert,update And Delete

And based on the packfactor,these instructions are executed say if you have pack factor of 9

Then 9 transaction data will be supplied to macros in 1 session based on the logic

In tpump job generally in most cases it is either INSERT or UPDATE these instructions will be executed by macros like wise

Say something like this

     CREATE MACRO TPUMP_MACRO
        (COL1,COL2,COL3)
     ) AS (
        INSERT INTO employee
        (COL1,COL2,COL3)
     VALUES
        (C1,C2,C3);

Fastload,Muliload Should do something like this

block of records at 1 time and perform the operation ..by block of records at a time

Its something like picking box of cherries

if less than 10 1 each --tpump

If more than 100---with help of a mug (fastload,mload) ...thats the way how I understood..

Looking for some good concrete proff on this

Although fastload,mload can also be used for records less than 10,000 perhaps

They have with maxload tasks factor as over head which causes them not use for data volume less than 10,000

Thanks

Krishna Rachur

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