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?

1131

What is collect statistics?

1007

Differentiate database data and data warehouse data?

1124

What does sleep function does in fast load?

1146

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

1184

Difference between multiload and tpump?

1120

What are the scenarios in which full table scans occurs?

1012

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

1096

How will you solve the problem that occurs during update?

1063

What is a dimension table?

1072

What are tpump utility limitations?

1130

How do you verify a complicated sql?

1071

How to eliminate product joins in a teradata sql query?

1043

How do you determine the number of sessions?

1067

How do you set the session mode parameters in bteq?

1112

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1202

How many tables can you join in v2r5?

1077

What are the multiload utility limitations?

1069

What is upsert statement in teradata?

1143

What are teradata utilities?

1116

When tpump is used instead of multiload?

1109

What is a three-tier data warehouse?

1122

What is a sparse index?

1092

What are the various indexes in teradata? How to use them? Why are they preferred?

1069

What are the enhanced features in teradata v2r5 and v2r6?

1138

Explain BYNET.

1009

What tools would you use for that?

1118

What is meant by Teradata Gateway?

1072

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2125

What are the newly developed features of Teradata?

1040

For More Un-Answered { Teradata } Questions Click Here