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 7043

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

TCS,

4 12056

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

Satyam,

1 12122

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 5575

Aborted in Phase 2 data acquistion completed in fastload?

2 5803

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

TCS,

3 15238

How do you Generate Sequence in Teradata?

TCS,

3 16131

How do you Generate sequence at the time of Display?

Infosys,

2 8414

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 9190

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

4 12872

Why Multiload does not supports USI and supports NUSI?

4 21626

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

IBM,

4 16833

which join mostly use in realtime?

TCS,

2 8115

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

3 7875

how to load or extract the error table data ?

3 7609

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is teradata and why it is used?

1088

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

1000

What are the available primary index types?

1208

What does sleep function does in fast load?

1129

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2155

How many sessions of MAX is PE capable of handling at a particular time?

1078

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

1107

What is a node in teradata? Explain

1000

any one answer me how they can analyzing the project using data ware housing?

2468

What interface is used to connect to windows based applications?

1108

How do you set the session mode parameters in bteq?

1097

What are the steps involved in the process flow of the sql statement through channel attached system?

1097

What do you mean by fastexport in teradata?

993

What are the joins in teradata?

982

Is multi insert ansi standard?

2201

For More Un-Answered { Teradata } Questions Click Here