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 7048

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

TCS,

4 12081

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

Satyam,

1 12133

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 5576

Aborted in Phase 2 data acquistion completed in fastload?

2 5804

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

TCS,

3 15266

How do you Generate Sequence in Teradata?

TCS,

3 16154

How do you Generate sequence at the time of Display?

Infosys,

2 8434

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 9208

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

4 12887

Why Multiload does not supports USI and supports NUSI?

4 21658

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

IBM,

4 16849

which join mostly use in realtime?

TCS,

2 8128

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

3 7891

how to load or extract the error table data ?

3 7627

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

2419

Highlight a few of the important components of Teradata?

1026

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1078

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

1112

How do you set the session mode parameters in bteq?

1102

Can you connect multiload from ab initio?

1215

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

1005

Why are oltp database designs not generally a good idea for a data warehouse?

1056

What are the 5 phases in a multiload utility?

1034

What is the meaning of Caching in Teradata?

1140

What is collect statistics?

998

Can we collect statistics on table level?

1034

What are the design features involved in teradata?

1056

What is meant by a Least Cost Plan?

1060

how do you manage the production space. what are the proactive methods you can take ?

1943

For More Un-Answered { Teradata } Questions Click Here