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 8134

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

1 5491

teradata support to automatically increase the character length or not?

1 5427

How to relege locks in fastload and multiload? example?

IBM,

4 23197

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 ?

2529

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

2 5184

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

2521

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

TCS,

4600

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

IBM,

6 10262

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

what is the default character set in teradata,,?

IBM, TCS,

2 11394

What is SQL Assistence?please eample

IBM,

4 8496

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

IBM,

2 6780

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 7266

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

IBM,

4 10349

Post New Teradata Questions

Un-Answered Questions { Teradata }

What is meant by Teradata Gateway?

1110

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1156

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

1049

What is the purpose of upsert command?

1261

Explain the parallel data extension in teradata?

1152

What are the available primary index types?

1276

What do you mean by fastexport in teradata?

1047

What is the difference between fastload and multiload?

1464

Where is teradata rdbms used?

1137

What is meant by a Channel Driver?

1332

Differentiate primary key and partition key?

1032

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

1090

What is the meaning of Caching in Teradata?

1185

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

1189

Describe primary index in teradata?

1049

For More Un-Answered { Teradata } Questions Click Here