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 7988

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

1 5417

teradata support to automatically increase the character length or not?

1 5355

How to relege locks in fastload and multiload? example?

IBM,

4 23021

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 ?

2482

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

2 5107

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

2483

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

TCS,

4559

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

IBM,

6 10055

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

what is the default character set in teradata,,?

IBM, TCS,

2 11291

What is SQL Assistence?please eample

IBM,

4 8351

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

IBM,

2 6681

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 7139

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

IBM,

4 10200

Post New Teradata Questions

Un-Answered Questions { Teradata }

How can we check the version of Teradata that we are using currently?

1070

Highlight the differences between Primary Key and Primary Index.

1097

What do you mean by teradata intellicloud?

1038

Explain fallback in teradata?

1067

What is dimensional modeling?

1090

What are the different table types that are supported by teradata?

1004

Comment whether bottleneck is an error or not.

1163

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

1059

How do you determine the number of sessions?

1064

What is the purpose of indexes?

1080

What are the different softwares used with their functions in teradata?

1017

What are the components provided on node?

1048

What do you mean by tpt in teradata?

1021

Why does varchar occupy 2 extra bytes?

1201

Difference between multiload and tpump?

1118

For More Un-Answered { Teradata } Questions Click Here