Teradata Interview Questions

Read Best Teradata Interview Questions and answers

#1 Question

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

#2 Question

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

#3 Question

Explain Teradata Architecture in detail with a diagram.

#4 Question

What are default access rights in teradata? What explicit right can be given to a User?

#5 Question

What happens in a conflict? How do you handle that?

#6 Question

Explain the Teradata Primary Index Mechanics in detail with a diagram.

#7 Question

In general, how do you optimze any SQL in Teradata?

#8 Question

What are the various indexes in Teradata? How to use them? Why are they preferred?

#9 Question

Some Data Warehousing concept questions like – What are dimentions, facts?

#10 Question

Explain and compare pros and cons of Snow Flake Schemas, and Start Schemas.

#11 Question

What is Spool Space? Why do you get spool space errors? How do trouble-shoot them?

#12 Question

Explain Stored Procedure in detail.. its structure…exact syntax .. in and out?

#13 Question

Why are they to be used? Compare it with a Macro.

#14 Question

How do you do Backup and recovery in Teradata?

#15 Question

What tools would you use for that?

#16 Question

How do you create tables – exact syntax, and create profiles, Users in Teradata?

#17 Question

How would you load a very large file in Teradata in general? What utility would you use for it? Why?

#18 Question

What are non-additive facts?

#19 Question

What are the different methods ot loading a dimension table? a fact table etc?

#20 Question

What are aggregate tables? How do you design them using Teradata?

An aggregate table is those tables which contain the summary of the existing warehouse. It is used to save the time as retrieving data from a million of records in the actual table will take too much time. So, aggregate the tables to a certain level of dimensions and use them.

Teradata supports some aggregate functions which are:

  • COUNT: It is used to count the rows.
  • SUM: used to calculate the sum of specified columns.
  • MIN: To find the minimum value from specified columns.
  • MAX: to find the maximum value from specified columns
  • AVG: to calculate the average of specified columns.
Ask a Question