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 ?

3624

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 5562

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 11115

Why do Hash joins usually perform better than Merge Joins?

1 7915

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,

4371

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 4231

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 2322

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,

1688

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the scenarios in which full table scans occurs?

1008

Explain how spool space is used.

1076

What is teradata and why it is used?

1098

What is the difference between union and union all in teradata?

1128

What is the difference between fastload and multiload? Which one is faster?

1223

What are the various etl tools in the market?

1073

Highlight the need for Performance Tuning.

1105

What are the available primary index types?

1222

What is meant by a Channel Driver?

1247

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

954

Comment whether bottleneck is an error or not.

1159

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

What is meant by a node?

1041

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

1175

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

1061

For More Un-Answered { Teradata } Questions Click Here