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 29417

Why AMP & PE are called Vprocs?

4 16753

Explain about Skew Factor?

TCS,

6 53188

How a Referential integrity is handled in Teradata?

5 23524

What is FILLER command in Teradata?

CTS, IBM,

9 32004

what is the difference between bpo and call centre?

American Solutions,

2 6123

Can any one plz provide the teradata interview questions?

10 16986

Diff b/w v2r5 and v2r6 ?

TCS,

3 11724

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 38927

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 59582

Post New Teradata Questions

Un-Answered Questions { Teradata }

Explain Teradata performance tuning and optimization?

1164

Can you connect multiload from ab initio?

1215

What is meant by a Channel Driver?

1247

What is partitioned primary index (ppi)?

1048

Describe the set operators in teradata.

1005

How do you verify a complicated sql?

1066

What are the newly developed features of Teradata?

1031

How is MLOAD Teradata Server restarted after execution?

1264

What tools would you use for that?

1109

Mention a few of the ETL tools that come under Teradata.

1079

What is meant by a node?

1041

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1153

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2121

How many codd's rules are satisfied by teradata database?

1112

Difference between inner join and outer join?

1026

For More Un-Answered { Teradata } Questions Click Here