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 ?

2143

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 3294

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 6687




Why do Hash joins usually perform better than Merge Joins?

1 5745

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

1223

how teradata fetches a row from primary index table?

1 1762

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

HP,

918

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

Wells Fargo, Infosys,

2805




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

569

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

Cognizant,

1 1757

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

Infosys,

531

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

561

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

iGate,

1 339

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

Wipro,

143

if collect stats but it show low confidence why?

IBM,

73


Post New Teradata Questions






Un-Answered Questions { Teradata }

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

779


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

923


what is object level locking ? where do appear this type of locking ?

2417


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

918


what are the day to day activities of teradata DBA ?

4298






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

2805


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

2114


what is sysdba and sysdbc ? which has high priority ?

2614


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1123


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

999


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1055


if collect stats but it show low confidence why?

73


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

852


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

569


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1056