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 ?

2985

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 4672

The transaction exceeded the maximum number of rowhash locks allowed

Wipro,

1 9889

Why do Hash joins usually perform better than Merge Joins?

1 6971

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

1946

how teradata fetches a row from primary index table?

1 2979

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

HP,

1683

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

Infosys, Wells Fargo,

3895

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

1268

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

Cognizant,

1 3360

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

Infosys,

1307

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

1258

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

iGate,

1 1546

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

Wipro,

1127

if collect stats but it show low confidence why?

IBM,

1171


Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the frequently used data types in teradata?

585


Why managing the data is important?

578


When tpump is used instead of multiload?

612


Explain BYNET.

594


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

601






What is meant by a Least Cost Plan?

609


Is multi insert ansi standard?

1732


What is called partitioned primary index (ppi)?

548


Why is the case expression used in teradata?

578


How is MLOAD Teradata Server restarted after execution?

635


How would you load a very large file in teradata in general?

547


Comment whether bottleneck is an error or not.

608


What are the functions of a teradata dba?

587


Explain parsing engine in teradata?

579


Explain the term 'columns' related to relational database management system?

537