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

Teradata Interview Questions

Questions Answers Views Company eMail

Why does varchar occupy 2 extra bytes?

1272

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

1105

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

1254

What do high confidence, low confidence and no confidence mean in explain plan?

1097

How many tables can you join in v2r5?

1117

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

1140

What is a three-tier data warehouse?

1154

Difference between stored procedure and macro?

1221

What is multi insert?

1111

Different phases of multiload?

1065

What is the maximum number of dml can be coded in a multiload script?

1157

Did you write stored procedures in teradata?

1187

What is inner join and outer join?

1170

How to view every column and the columns contained in indexes in teradata?

1100

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1319

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the primary characteristics of the Teradata.

1236

What is real time and near real time data warehousing?

1161

What are differences between teradata and ansi session modes in teradata?

1218

What are some primary characteristics of teradata?

1052

What are the various etl tools in the market?

1121

What is a node in teradata? Explain

1053

What is the purpose of upsert command?

1261

What is meant by Teradata Gateway?

1110

Explain amp in teradata?

1150

Explain PDE.

1132

How to view every column and the columns contained in indexes in teradata?

1100

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

1049

Explain the new features of teradata?

1092

In Teradata, how do we Generate Sequence?

1090

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?

1150

For More Un-Answered { Teradata } Questions Click Here