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

Teradata Interview Questions

Questions Answers Views Company eMail

Is multi insert ansi standard?

2250

How does hashing happens in teradata?

1145

What's the syntax of sub string?

1 2663

How many types of index are present in teradata?

1 1898

How to select first n records in teradata?

1160

What is a level of granularity of a fact table?

1219

What is logical data model?

1260

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

1102

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1156

What is the purpose of indexes?

1128

What type of indexing mechanism do we need to use for a typical data warehouse?

1226

Can we collect statistics on multiple columns?

1122

How do you create a table with an existing structure of another table with data and with no data?

1 1646

Can you load multiple data files for same target table using fastload?

1 1747

Can you connect multiload from ab initio?

1280

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is stored procedure in teradata?

1085

Difference between inner join and outer join?

1082

Syntax for case when statement?

1116

How to find duplicates in a table?

1273

How to load specific no.of records using bteq, or fastload,or multiload

1814

What is meant by a Least Cost Plan?

1106

How can you track login parameters of users in teradata?

1232

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

1143

What is the purpose of indexes?

1128

In Teradata, how do we Generate Sequence?

1088

How can bottlenecks be identified?

1060

What is meant by Teradata Gateway?

1110

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

1089

Why are oltp database designs not generally a good idea for a data warehouse?

1103

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1075

For More Un-Answered { Teradata } Questions Click Here