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 7955

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

1 5395

teradata support to automatically increase the character length or not?

1 5343

How to relege locks in fastload and multiload? example?

IBM,

4 22979

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 ?

2470

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

2 5087

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

2468

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 10011

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

what is the default character set in teradata,,?

IBM, TCS,

2 11256

What is SQL Assistence?please eample

IBM,

4 8306

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

IBM,

2 6650

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 7105

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

IBM,

4 10168

Post New Teradata Questions

Un-Answered Questions { Teradata }

How can you track login parameters of users in teradata?

1185

What are the different methods ot loading a dimension table? A fact table etc?

1030

What is partitioned primary index (ppi)?

1044

How many tables can you join in v2r5?

1065

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

2195

What are the uses of bynets in multi-node systems?

1026

Syntax for case when statement?

1056

If RDBMS is halted what will you do ?

2156

how do you manage the production space. what are the proactive methods you can take ?

1939

What are the newly developed features of Teradata?

1016

Why do you get spool space errors? How do trouble-shoot them?

1051

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

2048

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

1039

How do you verify a complicated sql?

1057

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

1059

For More Un-Answered { Teradata } Questions Click Here