Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

How do you design aggregate tables using teradata?

1 1711

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

1047

What are the various indexes in teradata? Why are they preferred?

1005

Explain teradata utilities. What is multiload, fast load, tpump?

1008

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

1168

What is spool space? Why do you get spool space errors?

1019

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

1112

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

984

What are the various indexes in teradata?

1046

Explain teradata architecture in detail with a diagram.

1113

How would you load a very large file in teradata in general?

1032

Why do you get spool space errors? How do trouble-shoot them?

1053

Explain and compare pros and cons of snow flake schemas?

1033

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

1036

What are default access rights in teradata?

1122

Post New Teradata Questions

Un-Answered Questions { Teradata }

How will you solve the problem that occurs during update?

1053

Explain some differences between mpp and smp?

1098

What is the purpose of upsert command?

1177

What are teradata utilities?

1109

Define views in teradata with general syntax.

1032

What is meant by a Virtual Disk?

1136

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1152

Explain teradata utilities. What is multiload, fast load, tpump?

1008

What are the design features involved in teradata?

1056

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

1047

Why does varchar occupy 2 extra bytes?

1192

What is a dimension table?

1063

Explain the term 'database' related to relational database management system?

984

Explain the term 'tables' related to relational database management system?

1047

if collect stats but it show low confidence why?

1686

For More Un-Answered { Teradata } Questions Click Here