Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata Interview Questions

Questions Answers Views Company eMail

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

IBM,

3 7980

If table have access lock.In the same table write lock is posible or not?

1 5405

teradata support to automatically increase the character length or not?

1 5353

How to relege locks in fastload and multiload? example?

IBM,

4 23007

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 ?

2480

any one pls tell me what are the table names in banking project?

2 5098

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

2476

what are the uses of fact table and dimension table in banking project?

TCS,

4556

what is the query for retrieve the unique values(not display the duplicates values) from single table?

IBM,

6 10043

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 12451

what is the default character set in teradata,,?

IBM, TCS,

2 11283

What is SQL Assistence?please eample

IBM,

4 8334

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

IBM,

2 6672

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

IBM,

3 7129

can we join volatile table with general table an global temporary table with general table ?

IBM,

4 10190

Post New Teradata Questions

Un-Answered Questions { Teradata }

How many sessions of MAX is PE capable of handling at a particular time?

1080

What do you mean by teradata intelliflex?

1104

What are some commonly used bteq scripts?

1009

What is meant by a Virtual Disk?

1136

What is meant by a Parsing Engine?

1188

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1259

In the Primary Index, what is the score of AMPs that are actively involved?

1078

Explain how spool space is used.

1076

Highlight the need for Performance Tuning.

1105

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

2414

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

2182

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

2163

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1045

Explain BYNET.

1003

For More Un-Answered { Teradata } Questions Click Here