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

Teradata Interview Questions

Questions Answers Views Company eMail

Can we load a Multi set table using MLOAD?

2 12456

What is the process to restart the multiload if it fails?

7 54998

What is use of compress in terdata?Explain?

11 36702

Why Fload doesn’t support multiset table?

9 29720

Why AMP & PE are called Vprocs?

4 16936

Explain about Skew Factor?

TCS,

6 53433

How a Referential integrity is handled in Teradata?

5 23687

What is FILLER command in Teradata?

CTS, IBM,

9 32298

what is the difference between bpo and call centre?

American Solutions,

2 6223

Can any one plz provide the teradata interview questions?

10 17287

Diff b/w v2r5 and v2r6 ?

TCS,

3 11846

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

IBM,

2 15550

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

IBM,

9 39262

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

Comsys, IBM,

4 27098

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 59979

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1047

What is a node in teradata? Explain

1053

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

1103

What is the purpose of upsert command?

1259

Explain the most common data types used in teradata?

1123

Explain fastload in teradata?

1145

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

1114

What are the components used in smp and massively parallel processing (mpp) machines?

1094

What are the functions performed by bynet?

1086

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

What are the design features involved in teradata?

1115

What is meant by Teradata Gateway?

1110

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

1103

What are the different functions performed in development phase?

1129

For More Un-Answered { Teradata } Questions Click Here