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 12339

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

7 54722

What is use of compress in terdata?Explain?

11 36264

Why Fload doesn’t support multiset table?

9 29338

Why AMP & PE are called Vprocs?

4 16707

Explain about Skew Factor?

TCS,

6 53150

How a Referential integrity is handled in Teradata?

5 23492

What is FILLER command in Teradata?

CTS, IBM,

9 31952

what is the difference between bpo and call centre?

American Solutions,

2 6106

Can any one plz provide the teradata interview questions?

10 16938

Diff b/w v2r5 and v2r6 ?

TCS,

3 11704

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

IBM,

2 15446

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

IBM,

9 38868

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

Comsys, IBM,

4 26868

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 59501

Post New Teradata Questions

Un-Answered Questions { Teradata }

How do you do backup and recovery in teradata?

1011

What is bteq utility in teradata?

961

Explain teradata utilities?

1032

Explain the parallel data extension in teradata?

1088

How many sessions of MAX is PE capable of handling at a particular time?

1078

What tools would you use for that?

1101

What is difference between user and database in teradata?

1063

What is dimensional modeling?

1078

What is meant by a Clique?

1055

What is meant by a dispatcher?

1008

What are tpump utility limitations?

1118

How do you verify a complicated sql?

1056

Define views in teradata with general syntax.

1020

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

999

What does Amp contain and what are all the operations that it performs?

995

For More Un-Answered { Teradata } Questions Click Here