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 7968

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

1 5398

teradata support to automatically increase the character length or not?

1 5348

How to relege locks in fastload and multiload? example?

IBM,

4 22994

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 ?

2474

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

2 5091

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

2469

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

TCS,

4554

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

IBM,

6 10029

"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 12440

what is the default character set in teradata,,?

IBM, TCS,

2 11267

What is SQL Assistence?please eample

IBM,

4 8320

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

IBM,

2 6661

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 7114

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

IBM,

4 10176

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is the difference between teradata and basic rdbms?

1013

In Teradata, how do we Generate Sequence?

1041

Difference between inner join and outer join?

1020

In BTEQ, how are the session-mode parameters being set?

1143

Explain teradata utilities. What is multiload, fast load, tpump?

1006

Did you write stored procedures in teradata?

1129

While creating table my dba has fallback or no fallback in his ddl. What is that?

1181

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

1009

What are the steps to create a data model?

1050

What is TPD?

1369

What are the enhanced features in teradata v2r5 and v2r6?

1134

How do you do backup and recovery in teradata?

1014

Explain the types of join supports by teradata?

990

What is the purpose of indexes?

1069

What is the use of stored procedures in teradata?

997

For More Un-Answered { Teradata } Questions Click Here