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 6675

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

1 4527

teradata support to automatically increase the character length or not?

1 4666

How to relege locks in fastload and multiload? example?

IBM,

4 21392

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 ?

1897

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

2 4100

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

2028

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

TCS,

4104

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

IBM,

6 8088

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

what is the default character set in teradata,,?

IBM, TCS,

2 10195

What is SQL Assistence?please eample

IBM,

4 6624

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

IBM,

2 5630

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 5945

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

IBM,

4 8684


Post New Teradata Questions

Un-Answered Questions { Teradata }

Mention a few of the ETL tools that come under Teradata.

621


What do you mean by tpt in teradata?

593


Is multi insert ansi standard?

1751


Describe primary index in teradata?

588


Highlight a few of the important components of Teradata?

586






What is the difference between teradata and oracle?

558


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1280


When tpump is used instead of multiload?

629


What are the different functions included in the server software?

603


How do you create tables? Exact syntax, and create profiles, users in teradata?

559


What are the various indexes in teradata? Why are they preferred?

561


What are some commonly used bteq scripts?

567


What is the difference between union and union all in teradata?

624


what is sysdba and sysdbc ? which has high priority ?

3372


Highlight the points of differences between the database and user in Teradata.

591