Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category
Teradata Interview Questions
Questions Answers Views Company eMail

Can any one please provide me practical example of How to do the performance tuning in Query??

Amdocs,

5 10860

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 13355

What is collect State in Teradata ? what it use and how it works??

TCS,

3 12116

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

Accenture,

5 33178

What is the difference between correlated sub queries and inner queries?

 4 15059

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

CTS, TCS,

5 14090

Where we use PPI in real time??? What is the disadvantages of PPI?

IBM, Mphasis,

3 9889

What is the Maximum number of volatile tables that can be created?

Mphasis,

4 9455

What is a pseudo key? What is its use???

Mphasis,

2 18231

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

IBM,

2 8814

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

Mphasis,

3 12513

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

CTS, Lexicon,

3 15824

What is differnce between Error code and Error Level in Bteq

IBM,

6 38056

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

IBM,

6 20268

What is the default join strategy in Teradata???

IBM,

5 24326

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

864

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

790

How many types of joins are there in teradata?

735

What is meant by a Highest Cost Plan?

828

Which is more efficient group by or distinct to find duplicates?

875

How can we check the version of Teradata that we are using currently?

831

Describe primary index in teradata?

781

What is stored procedure in teradata?

789

How would you load a very large file in teradata in general? What utility would you use for it? Why?

864

What are some commonly used bteq scripts?

768

What are the things to be considered while creating secondary index?

856

Explain and compare pros and cons of start schemas?

780

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

819

What are the newly developed features of Teradata?

793

What are the steps involved after the disk manager passes the request?

815

For More Un-Answered { Teradata } Questions Click Here