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 7050

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

TCS,

4 12086

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

Satyam,

1 12135

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 5577

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 15267

How do you Generate Sequence in Teradata?

TCS,

3 16157

How do you Generate sequence at the time of Display?

Infosys,

2 8435

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 9210

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

4 12888

Why Multiload does not supports USI and supports NUSI?

4 21660

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

IBM,

4 16852

which join mostly use in realtime?

TCS,

2 8135

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

3 7891

how to load or extract the error table data ?

3 7628

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is bteq script in teradata?

1155

List out all forms of LOCKS that are available in Teradata.

969

How does hashing happens in teradata?

1091

Explain teradata utilities. What is multiload, fast load, tpump?

1008

Difference between star and snowflake schemas?

1152

What are tpump utility limitations?

1118

What is the difference between fastload and multiload?

1380

How to find duplicates in a table?

1218

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

2476

What is the use of virtual processor connectivity in teradata?

1028

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

1195

if collect stats but it show low confidence why?

1688

What is the difference between teradata and basic rdbms?

1023

What is meant by a dispatcher?

1021

Highlight the advantages of PPI(Partition Primary Index).

1076

For More Un-Answered { Teradata } Questions Click Here