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

Teradata Interview Questions

Questions Answers Views Company eMail

How to Extract data from multiple legacy systems?

1172

What is collect statistics?

1048

Differentiate database data and data warehouse data?

1162

What does sleep function does in fast load?

1207

What is the command in bteq to check for session settings ?

1232

Difference between multiload and tpump?

1157

What are the scenarios in which full table scans occurs?

1052

Which is more efficient group by or distinct to find duplicates?

1129

How will you solve the problem that occurs during update?

1104

What is a dimension table?

1099

What are tpump utility limitations?

1176

How do you verify a complicated sql?

1114

How to eliminate product joins in a teradata sql query?

1085

How do you determine the number of sessions?

1106

How do you set the session mode parameters in bteq?

1139

Post New Teradata Questions

Un-Answered Questions { Teradata }

Can we collect statistics on table level?

1092

What is a dimension table?

1099

What is meant by a Least Cost Plan?

1106

What do you mean by caching in teradata?

1103

What are the various reporting tools in the market?

1115

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2220

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1257

Explain Teradata performance tuning and optimization?

1223

What is logical data model?

1260

What is upsert statement in teradata?

1191

What is the difference between teradata and oracle?

1065

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

901

Difference between stored procedure and macro?

1218

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2242

What is meant by a node?

1075

For More Un-Answered { Teradata } Questions Click Here