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 10925

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 13406

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

TCS,

3 12184

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

Accenture,

5 33239

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

4 15114

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 14173

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

IBM, Mphasis,

3 9941

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

Mphasis,

4 9509

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

Mphasis,

2 18296

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 8867

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 12579

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 15861

What is differnce between Error code and Error Level in Bteq

IBM,

6 38157

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 20351

What is the default join strategy in Teradata???

IBM,

5 24402


Post New Teradata Questions

Un-Answered Questions { Teradata }

What do you mean by teradata intellicloud?

834


Explain the most common data types used in teradata?

814


What is a three-tier data warehouse?

849


What is called partitioned primary index (ppi)?

785


What do you mean by parsing?

862


What are the various indexes in teradata? How to use them?

795


Explain amp in teradata?

788


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3161


What is teradata? What are some primary characteristics of teradata?

775


What is the use of teradata system software?

809


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

870


Discuss the advantages of using partitioned primary index in a query?

765


What are the functions of a Parser?

835


Explain the meaning of Amp?

796


How is MLOAD Teradata Server restarted after execution?

938