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 12356

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

7 54759

What is use of compress in terdata?Explain?

11 36320

Why Fload doesn’t support multiset table?

9 29415

Why AMP & PE are called Vprocs?

4 16750

Explain about Skew Factor?

TCS,

6 53188

How a Referential integrity is handled in Teradata?

5 23523

What is FILLER command in Teradata?

CTS, IBM,

9 32004

what is the difference between bpo and call centre?

American Solutions,

2 6120

Can any one plz provide the teradata interview questions?

10 16985

Diff b/w v2r5 and v2r6 ?

TCS,

3 11723

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

IBM,

2 15464

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

IBM,

9 38926

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

Comsys, IBM,

4 26898

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 59581

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1015

What do you mean by tpt in teradata?

1021

Define views in teradata with general syntax.

1032

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1043

What is the basic syntax for teradata select statement?

1044

What is meant by a Parsing Engine?

1188

Describe the between keyword in teradata?

1040

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3623

In Teradata, what is the significance of UPSERT command?

1234

How to eliminate product joins in a teradata sql query?

1029

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

1036

What type of indexing mechanism do we need to use for a typical data warehouse?

1166

What do you mean by teradata intelliflex?

1104

What are the various reporting tools in the market?

1070

What are teradata utilities?

1111

For More Un-Answered { Teradata } Questions Click Here