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 ?

3693

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 5640

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 11218

Why do Hash joins usually perform better than Merge Joins?

1 8045

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

2470

how teradata fetches a row from primary index table?

1 3801

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

HP,

2242

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

Infosys, Wells Fargo,

4421

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

1786

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

Cognizant,

1 4398

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

Infosys,

1816

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

1825

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

iGate,

1 2403

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

Wipro,

1657

if collect stats but it show low confidence why?

IBM,

1749

Post New Teradata Questions

Un-Answered Questions { Teradata }

Can we collect statistics on table level?

1092

Define views in teradata with general syntax.

1087

Highlight all the modes that are present under Confidence Level.

1011

how many modules are there in telecome domain?how to explain the architecture?

2064

Highlight the limitations of TPUMP Utility.

1174

What are the functions of a teradata dba?

1126

How many tables can you join in v2r5?

1117

What are the components used in smp and massively parallel processing (mpp) machines?

1095

What is the command in bteq to check for session settings ?

1233

What is stored procedure in teradata?

1087

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

1107

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

1073

Explain teradata utilities?

1093

How to eliminate product joins in a teradata sql query?

1085

What is a sparse index?

1121

For More Un-Answered { Teradata } Questions Click Here