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 7347

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

1 5077

teradata support to automatically increase the character length or not?

1 5029

How to relege locks in fastload and multiload? example?

IBM,

4 22151

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 ?

2209

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

2 4674

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

2257

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

TCS,

4351

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

IBM,

6 9117

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

what is the default character set in teradata,,?

IBM, TCS,

2 10762

What is SQL Assistence?please eample

IBM,

4 7518

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

IBM,

2 6118

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 6584

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

IBM,

4 9454


Post New Teradata Questions

Un-Answered Questions { Teradata }

Describe the set operators in teradata.

803


What is the purpose of using case expression in teradata?

806


What are the available join types in teradata?

844


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

812


Explain the meaning of Amp?

796


What are the components provided on node?

846


how can we analyze the locks ?

1907


What is smp and mpp platforms?

752


Describe primary index in teradata?

799


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

625


What tools would you use for that?

842


How can bottlenecks be identified?

795


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

820


Explain parsing engine in teradata?

839


How do you define Teradata?

860