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

Teradata Interview Questions

Questions Answers Views Company eMail

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3623

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

Wipro,

1 5559

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 11115

Why do Hash joins usually perform better than Merge Joins?

1 7913

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

2419

how teradata fetches a row from primary index table?

1 3736

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

HP,

2182

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

Infosys, Wells Fargo,

4370

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1737

How to cast date "2015-03-03-012204-000000" to timestamp

Cognizant,

1 4229

How to load specific no.of records using bteq, or fastload,or multiload

Infosys,

1747

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

In your project what type of issues and errors you facing in Teradata

iGate,

1 2320

Find 2 highest sal from each dept who have completed 5 year in org

Wipro,

1609

if collect stats but it show low confidence why?

IBM,

1686

Post New Teradata Questions

Un-Answered Questions { Teradata }

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

What are the functions performed by bynet?

1041

What are aggregate tables? How do you design them using teradata?

1169

Explain teradata vs. Redshift?

1016

What tools would you use for that?

1109

Can you fastexport a field, which is primary key by putting equality on that key?

1178

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

985

What is meant by a dispatcher?

1021

What are some commonly used bteq scripts?

1009

What is spool space?

1158

Why teradata is used?

1006

Discuss the advantages of using partitioned primary index in a query?

952

What is the syntax for case when statement?

1143

What are the various indexes in teradata? How to use them?

1012

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

1080

For More Un-Answered { Teradata } Questions Click Here