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 5560

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 4230

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 }

What is logical data model?

1203

What is oltp?

977

How does hashing happens in teradata?

1088

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1113

if collect stats but it show low confidence why?

1686

If RDBMS is halted what will you do ?

2168

How do you see a ddl for an existing table?

1018

List the logical and conditional operators that are used with teradata along with their meanings?

1002

What are the different softwares used with their functions in teradata?

1015

When tpump is used instead of multiload?

1104

Explain fallback in teradata?

1060

What do you mean by fastexport in teradata?

999

How to view every column and the columns contained in indexes in teradata?

1056

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

2182

How to select first n records in teradata?

1106

For More Un-Answered { Teradata } Questions Click Here