Teradata Interview Questions and Answers

Teradata Interview Questions and Answers

Teradata Corporation is a provider of database-related products and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers at Caltech and Citibank’s advanced technology group. The company was acquired by NCR Corporation in 1991, and subsequently spun-off again as an independent public company on October 1, 2007.

Teradata began to market with the term “big data” in 2010. CTO Stephen Brobst attributed the rise of big data to “new media sources, such as social media. The increase in semi-structured and unstructured data gathered from online interactions prompted Teradata to form the “Petabyte club” in 2011 for its heaviest big data users. (Wikipedia says)

What is Teradata?

Why Teradata?

Can you explain the architecture of Teradata?

Can you define Primary Index?

What is Partitioned Primary Index (PPI) and discuss the Pros of using it in a query?

Can you explain Unique Primary Index (UPI)?

Can you explain Non-Unique Primary Index (NUPI)?

Can you define Secondary Index?

Can you define Join Index?

Can you explain TPUMP?

Can you define TPT?

Can you define BTEQ? And features of BTEQ?

What are the BTEQ Scripts?

What are the different types of BTEQ Exports?

How do you transfer large amount of data in Teradata?

What are the steps involved after the disk manager passes the request?

What is OLTP?

What is Multi Insert?

What is Caching in Teradata?

What is a permanent Journal in Teradata?

What is UPSERT command?

What is filler command in Teradata?

Can you define Data Modeling?

Can you define Dimensional Modeling?

What is set operators in Teradata?

How to eliminate product joins in a Teradata SQL query?

What are the types of tables in Teradata?

Can you define Logical Data Model?

What is ODS?

What is Subject Area?

What is a Checkpoint?

Can you define Data Warehousing?

What is a three-tier data warehouse?

Can you define GTT?

Can you define ETL?

What can be achieved by using the Teradata RDBMS?

Can you explain Staging Area?

What are differences between Teradata and ANSI session modes in Teradata?

What are the features of Teradata?

What are the basic rules that define how pi is defined in Teradata?

What are the functions of a Teradata DBA?

Can you explain Teradata database Data Protection?