Teradata Interview Questions

What is Teradata BTEQ?
What are the teradata Objects?
What are the Teradata tools and utilities?
What is the difference between v2r5 and v2r6?
How to find average sal without using avg function?
Why multiload supports only NUSI?
Any three differences between teradata 12 and teradata 13?
What is join index?what are the types of join index?
What is Teradata fastload,multiload and Tpump ? 
What is error handling in Bteq?
What is skewness in Teradata?
Difference between fastload and multiload in Teradata?
Difference between General DELETE and Multiload DELETE in Teradata?
Difference between BTEQ export and fast export?
When we will use nullif function?
What is the use of coalesce function ?
What is the role of Secondary Index(SI) and explain its types?
How many primary keys we will apply on table?
Difference between SMP and MPP?
Explain Shared Nothing Architecture?
Difference between subquery and correlated subquery ?
What are the join Strategies?
What are the limitations of fastload and multiload?
Explain different phases of fastload and multiload?


  1. Hi all,

    BTEQ, short for basic TEradata query, is a general-purpose command-driven utility used to access and manipulate data on the Teradata database and format reports for both print and screen output. Thanks for sharing it....

  2. These are brilliant questions! Hiring analysts, especially contractors, who know the difference between multiload, fastload, and TPUMP is almost impossible. I will definitely be using these questions for our next interview. Thanks!