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 12235

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

7 54471

What is use of compress in terdata?Explain?

11 35934

Why Fload doesn’t support multiset table?

9 29066

Why AMP & PE are called Vprocs?

4 16573

Explain about Skew Factor?

TCS,

6 52957

How a Referential integrity is handled in Teradata?

5 23340

What is FILLER command in Teradata?

CTS, IBM,

9 31697

what is the difference between bpo and call centre?

American Solutions,

2 6003

Can any one plz provide the teradata interview questions?

10 16616

Diff b/w v2r5 and v2r6 ?

TCS,

3 11584

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

IBM,

2 15366

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

IBM,

9 38590

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

Comsys, IBM,

4 26713

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 59133

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the functions of a Parser?

1040

How do you see a ddl for an existing table?

971

Differentiate primary key and partition key?

947

why use references rather than pointers in the public api, particularly for arguments which are modified?

951

How is MLOAD Client System restarted after execution?

1070

Differentiate database data and data warehouse data?

1062

Explain fallback in teradata?

991

What is the purpose of indexes?

1021

Highlight all the modes that are present under Confidence Level.

932

What is oltp?

928

What happens in a conflict? How do you handle that?

999

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

958

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

1132

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

1006

Highlight the advantages of PPI(Partition Primary Index).

1019

For More Un-Answered { Teradata } Questions Click Here