What is the BTEQ script in Teradata?

devquora
devquora

Posted On: Feb 22, 2018

 

BTEQ utility or script is a powerful utility in Teradata that can be used in both the batch and interactive mode. It can be also used to run any DDL statement, DML statement, create Macros and stored procedures. BTEQ can be used to import data into Teradata tables from flat file and it can also be used to extract data from tables into files or reports.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Teradata Interview Questions

    Explain Teradata utilities. What is MultiLoad , Fast Load, Tpump ?

    Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time. FastLoad can sort the incoming rows directly into the target table. MultiLoad first...

    Teradata Interview Questions

    When do you use each of these? Why? Explain in detail.

    It is used because Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time....

    Teradata Interview Questions

    Explain Teradata Architecture in detail .

    Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET, and Access Module Processors (AMPs)....