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 ?

2167

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 3333

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 6831




Why do Hash joins usually perform better than Merge Joins?

1 5778

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

1248

how teradata fetches a row from primary index table?

1 1791

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

HP,

941

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

Wells Fargo, Infosys,

2869




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

592

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

Cognizant,

1 1798

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

Infosys,

548

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

577

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

iGate,

1 382

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

Wipro,

382

if collect stats but it show low confidence why?

IBM,

365


Post New Teradata Questions






Un-Answered Questions { Teradata }

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

2153


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

2167


how can we analyze the locks ?

980


If RDBMS is halted what will you do ?

1030


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

1013






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

793


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

1248


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

1075


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?

943


any one answer me how they can analyzing the project using data ware housing?

1387


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

910


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

941


if collect stats but it show low confidence why?

365


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

2869


If a Node is busy what are the steps you can take to avoid ?

1233