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 12354

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

7 54754

What is use of compress in terdata?Explain?

11 36314

Why Fload doesn’t support multiset table?

9 29409

Why AMP & PE are called Vprocs?

4 16745

Explain about Skew Factor?

TCS,

6 53184

How a Referential integrity is handled in Teradata?

5 23518

What is FILLER command in Teradata?

CTS, IBM,

9 32002

what is the difference between bpo and call centre?

American Solutions,

2 6120

Can any one plz provide the teradata interview questions?

10 16983

Diff b/w v2r5 and v2r6 ?

TCS,

3 11722

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

IBM,

2 15462

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

IBM,

9 38922

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

Comsys, IBM,

4 26897

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 59576

Post New Teradata Questions

Un-Answered Questions { Teradata }

Explain the teradata primary index mechanics in detail with a diagram.

976

What are normalization, first normal form, second normal form and third normal form?

1052

If RDBMS is halted what will you do ?

2168

Steps to create a data model?

1132

What do you mean by teradata intelliflex?

1100

What is the purpose of indexes?

1074

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?

1203

Highlight all the modes that are present under Confidence Level.

971

Explain teradata architecture in detail with a diagram.

1113

How do you see a ddl for an existing table?

1018

What are the different softwares used with their functions in teradata?

1015

What is collect statistics?

998

What are the steps to create a data model?

1053

What is smp and mpp platforms?

971

What happens when a node suffers a downfall?

1129

For More Un-Answered { Teradata } Questions Click Here