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?

2201

How does hashing happens in teradata?

1081

What's the syntax of sub string?

1 2571

How many types of index are present in teradata?

1 1797

How to select first n records in teradata?

1097

What is a level of granularity of a fact table?

1148

What is logical data model?

1198

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

1048

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

1094

What is the purpose of indexes?

1067

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

1158

Can we collect statistics on multiple columns?

1055

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

1 1571

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

1 1669

Can you connect multiload from ab initio?

1207

Post New Teradata Questions

Un-Answered Questions { Teradata }

What's the difference between timestamp (0) and timestamp (6)?

1180

What is smp and mpp platforms?

968

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

977

List the logical and conditional operators that are used with teradata along with their meanings?

999

Differentiate primary key and partition key?

979

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

1093

What is teradata? Also, list out some of the primary characteristics of teradata.

1050

What are the functions of a Parser?

1096

What do you mean by fastexport in teradata?

993

What is meant by a dispatcher?

1008

Explain and compare pros and cons of snow flake schemas?

1029

What are the things to be considered while creating secondary index?

1094

What are the steps involved in the process flow of the sql statement through channel attached system?

1097

What is a dimension table?

1049

What are the various etl tools in the market?

1067

For More Un-Answered { Teradata } Questions Click Here