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 6937

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

TCS,

4 11870

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

Satyam,

1 11982

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 5445

Aborted in Phase 2 data acquistion completed in fastload?

2 5688

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

TCS,

3 15097

How do you Generate Sequence in Teradata?

TCS,

3 15962

How do you Generate sequence at the time of Display?

Infosys,

2 8262

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 8983

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

4 12686

Why Multiload does not supports USI and supports NUSI?

4 21425

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

IBM,

4 16677

which join mostly use in realtime?

TCS,

2 8009

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

3 7701

how to load or extract the error table data ?

3 7460

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

1125

What exactly do you know about catching in teradata?

991

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

1014

What are some commonly used bteq scripts?

945

Which is faster fastload or multiload?

1045

Explain the most common data types used in teradata?

988

What is a level of granularity of a fact table?

1074

What are differences between teradata and ansi session modes in teradata?

1096

What are the enhanced features in teradata v2r5 and v2r6?

1079

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

911

How to view every column and the columns contained in indexes in teradata?

982

What is meant by a Channel Driver?

1142

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2149

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1152

What can be achieved by using the teradata rdbms?

983

For More Un-Answered { Teradata } Questions Click Here