Teradata Interview Questions and Answers

Last updated on Mar 21, 2022
  • Share
Teradata Interview Questions

Most Frequently Asked Teradata Interview Questions

Here in this article, we will be listing frequently asked Teradata Interview Questions and Answers with the belief that they will be helpful for you to gain higher marks. Also, to let you know that this article has been written under the guidance of industry professionals and covered all the current competencies.

Q11. What is BTEQ script in Teradata?

BTEQ or Basic Teradata Query Script is a file present in Teradata which contains BTEQ commands and SQL statements. The BTEQ script is built for command sequences that are going to be executed on more than one occasion, which can be daily, weekly or monthly.

Q12. What are different table types used in Teradata?
There have four table types supported in Teradata:
  • Permanent Table: It’s the default table and contains data put by the user and stores that data permanently.
  • Global Temporary Table: Persistent but the data present in the table will be deleted at the end of the user session.
  • Volatile Table: The data into this table is retained only during the user session.
  • Derived Table: It holds the intermediate results in a query. The lifetime of this table depends on the query in which they are created, dropped and used.

This is a fundamental question in teradata interview questions.

Q13. What is the primary index in Teradata?

In Teradata, the primary index is an index present on a set of fields which includes the primary key for the field and is guaranteed not to contain any duplicates.

There are two types of primary indexes:
  • UPI / Unique Primary Index
  • NUPI /Non-Unique Primary Index
Q14. Explain the new features of Teradata?

Enlisted new features added to the Teradata:

  • New string functions added; PIVOT and UNPIVOT
  • Addition of DATASET datatype
  • Performance improvement in COUNT DISTINCT
  • Introduction of Global Space Accounting
  • Unicode Pass-Through added
  • Increased PERM and Response Rows (1 MB)
  • More choice added to Compression Table-Level Option
Q15. Explain fastload in Teradata?

In Teradata, fastload is a utility which can be used by developers to load a large amount of data in an empty table on a Teradata system. Its unique features include increased speed to load a huge amount of data in tables.

Q16. What do you mean by fastexport in Teradata?

In Teradata, FastExport is a utility used to export data from Teradata tables into flat files. Teradata – FastExport can also generate the data in report format,

Q17. What is the use of UPSERT COMMAND In Teradata?

Developers use the UPSERT command inserts rows that do exist. It can be achieved using UPDATE-ELSE-INSERT or MERGE.

Q18. Explain the most common data types used in Teradata?

Here are the common data types used in Teradata:

  • Byteint
  • Smallint
  • Integer
  • Bigint
  • Decimal
  • Numeric
  • Float
  • Date
  • Varchar
  • Time
  • Timestamp
Q19. What do you mean by Caching in Teradata?
Q20. What is a node in Teradata? Explain

Node is a term used for the processing unit (General Purpose) which is controlled by a single operating system. Node is known as the basic building block of Teradata System. The Node is the destination where the processing occurs for the database.

Reviewed and verified by Best Interview Question
Best Interview Question

With our 10+ experience in PHP, MySQL, React, Python & more our technical consulting firm has received the privilege of working with top projects, 100 and still counting. Our team of 25+ is skilled in...