Explore topic-wise InterviewSolutions in .

Functioning of BTEQ UTILITY in TERADATA?
BTEQ is one of most powerful utility in Teradata which is useful for both Batch and Interactive mode. BTEQ is USED to run DDL statement, DML statement, create macros and store procedures. One of the important USE of BTEQ to import data from a flat-file. BTEQ is also useful to extract data from tables into files or in REPORTS.

Basic definition of Teardata?
When we have a large-scale data warehousing application Teradata is perfect selection. Teradata is Relational Database MANAGEMENT System (RDBMS). It is an open system. And it is also perfect for parallelism concept. Teradata can RUN on Windows, LINUX and Unix server platform. Teradata have the feature to support multiple data warehouse operations at the same time to different clients.
Teradata is developed by American IT firm whose name is Teradata corporation. It deal with analytic data platforms, applications, and other related services. Below are the characteristics of Teradata:-
(1)Teradata is a single
(2)Teradata is built on parallelism
(3)Teradata is open system.
(4)Teradata has multi NODE running capabilities
(5)Teradata acts as same as server does.
(6)Teradata is compatible with the ANSI(American NATIONAL Standards Institute)