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 1712

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

1047

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

1006

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

1008

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

1170

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

1020

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?

987

What are the various indexes in teradata?

1049

Explain teradata architecture in detail with a diagram.

1113

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

1034

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

1055

Explain and compare pros and cons of snow flake schemas?

1035

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

1036

What are default access rights in teradata?

1123

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1066

How will you solve the problem that occurs during update?

1055

What is the purpose of upsert command?

1177

Explain fastload in teradata?

1104

List out some of the primary characteristics of teradata.

1006

What exactly do you know about catching in teradata?

1038

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1169

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1113

While creating table my dba has fallback or no fallback in his ddl. What is that?

1186

Explain and compare pros and cons of snow flake schemas?

1035

What are normalization, first normal form, second normal form and third normal form?

1052

What is the difference between global temporary tables and volatile temporary tables?

1182

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2419

What is the difference between teradata and oracle?

1027

How does hashing happens in teradata?

1091

For More Un-Answered { Teradata } Questions Click Here