Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

IBM,

2 7138

why should we go Teradata over Oracle,what is the main differences?

TCS,

4 12267

How do you load Multiple files to a table by using fastload scripts?

Satyam,

1 12240

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 5677

Aborted in Phase 2 data acquistion completed in fastload?

2 5908

Fast Load Script is failed and error tables are available then how do you restart?

TCS,

3 15386

How do you Generate Sequence in Teradata?

TCS,

3 16310

How do you Generate sequence at the time of Display?

Infosys,

2 8571

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

IBM,

4 9398

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 13062

Why Multiload does not supports USI and supports NUSI?

4 21860

How to run the Teradata jobs in unix environment ???

IBM,

4 16985

which join mostly use in realtime?

TCS,

2 8273

How to copy teradata scripts from ur remote desktop to server machine?

3 8012

how to load or extract the error table data ?

3 7768

Post New Teradata Questions

Un-Answered Questions { Teradata }

Explain teradata architecture in detail with a diagram.

1167

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1213

Explain the term 'tables' related to relational database management system?

1103

During the Display time, how is the sequence generated by Teradata?

1121

What are the various indexes in teradata? Why are they preferred?

1053

Explain the term 'row' related to relational database management system?

999

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1081

What is meant by a Least Cost Plan?

1106

What is the use of having index on table?

1040

What is a dimension table?

1102

Explain some differences between mpp and smp?

1157

How would you load a very large file in teradata in general?

1090

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2470

What do you mean by caching in teradata?

1103

If a Node is busy what are the steps you can take to avoid ?

2457

For More Un-Answered { Teradata } Questions Click Here