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 7845

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

1 5330

teradata support to automatically increase the character length or not?

1 5278

How to relege locks in fastload and multiload? example?

IBM,

4 22799

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 ?

2427

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

2 5005

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

2420

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

TCS,

4503

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

IBM,

6 9841

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

what is the default character set in teradata,,?

IBM, TCS,

2 11168

What is SQL Assistence?please eample

IBM,

4 8171

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

IBM,

2 6526

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 6980

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

IBM,

4 10004

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the design features involved in teradata?

993

What is bteq script in teradata?

1094

What is the use of having index on table?

962

What is partitioned primary index (ppi)?

1012

In general, how do you optimze any sql in teradata?

990

What are the commands to make a new table, change a table and remove a table in teradata?

1082

Explain and compare pros and cons of snow flake schemas?

990

What exactly do you know about catching in teradata?

998

why use references rather than pointers in the public api, particularly for arguments which are modified?

951

Describe primary index in teradata. And what are the available primary index types?

955

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

988

What is basic teradata query language?

1051

if collect stats but it show low confidence why?

1634

What are the steps to create a data model?

997

List out some of the primary characteristics of teradata.

929

For More Un-Answered { Teradata } Questions Click Here