teradata load utility

Tools
deb
Fan

teradata load utility

Hi,

can anyone guide me which is the correct tool for continous update in teradata table?
is it multiload or tpump?
i got confused because i found in the basic certification that for one question where the answer for continous upadte tpump is used while in another question where we have drag the multiload for update.

so please let me know which is the correct answer.

thanks in advance for ur suggestions.

regards
deb
3 REPLIES
SN
Enthusiast

Re: teradata load utility

hi,

TPUMP is apt for continuous near real-time updates whereas MLOAD is used for batch updates with very high volume.

thx,
Fan

Re: teradata load utility

Hi,

T-Pump is for continues load, Mload is bulk load utilite.
Enthusiast

Re: teradata load utility

Hey Deb,

see, we can choose any of the utility tools based on req...

-- Tpump is more efficient if you want to perform loading in conitiniously & constant loading of the data upto multiple tables E.x , Real time updates , Online transaction system

-- its perform is high & load the data very fast against small amount of data where as mload will be slow

-- Where as Multiload is more efficient if you want to performa INS/Update/Del for against large amount of data .

Regards,
Maran
Oracle Certified & DW+BI Proff