BTEQ,Tpump,Fastload,Multiload

Tools & Utilities
Enthusiast

BTEQ,Tpump,Fastload,Multiload

Match the utility to the task most suitable to it ?
Load 10M rows to an empty table Tpump
update 100K rows Multiload
Extract 100rows for a report BTEQ
Continuous load with changing load rate Fastload
Please tell me is it true?If not ,Please give me an answer,Thank you!
1 REPLY
Teradata Employee

Re: BTEQ,Tpump,Fastload,Multiload

Hello,

It will be as follows:

Load 10M rows to an empty table: FastLoad
Update 100K rows: Multiload
Extract 100rows for a report: BTEQ
Continuous load with changing load rate: TPump

HTH.

Regards,

Adeel