1.

How Do You Transfer Large Amount Of Data In Teradata?

Answer»

Transferring of LARGE AMOUNT of data can be done USING various Application Teradata UTILITIES which resides on the host computer ( Mainframe or Workstation) i.e. BTEQ, FastLaod, MultiLoad, Tpump and FastExport.

  • BTEQ (Basic Teradata QUERY) supports all 4 DMLs: SELECT, INSERT, UPDATE and DELETE. BTEQ also support IMPORT/EXPORT protocols.
  •  Fastload, MultiLoad and Tpump transfer the data from Host to Teradata.
  •  FastExport is used to export data from Teradata to the Host.

     

Transferring of large amount of data can be done using various Application Teradata Utilities which resides on the host computer ( Mainframe or Workstation) i.e. BTEQ, FastLaod, MultiLoad, Tpump and FastExport.

 


Discussion

No Comment Found

Related InterviewSolutions