1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category
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 6637

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

 1 4505

teradata support to automatically increase the character length or not?

 1 4638

How to relege locks in fastload and multiload? example?

IBM,

4 21357

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 ?

1885

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

 2 4053

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

 2020

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

TCS,

4080

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

IBM,

6 8033

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

what is the default character set in teradata,,?

IBM, TCS,

2 10153

What is SQL Assistence?please eample

IBM,

4 6561

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

IBM,

2 5586

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 5905

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

IBM,

4 8648

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are types of partition primary index (ppi) in teradata?

578

Why teradata is used?

566

What is oltp?

557

What is collect statistics?

576

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

575




Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

692

What is inner join and outer join?

604

What are the functions involved in shared information architecture?

588

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

558

Explain the advantages of partitioned primary index in a query?

551

Is multi insert ansi standard?

1733

How will you solve the problem that occurs during update?

568

What is the basic syntax for teradata select statement?

565

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

617

Explain fastload in teradata?

588

For More Un-Answered { Teradata } Questions Click Here