Teradata Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 11463

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 13907

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

TCS,

3 12798

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

Accenture,

5 34057

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

4 15643

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 15016

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

IBM, Mphasis,

3 10562

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

Mphasis,

4 10050

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

Mphasis,

2 18777

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 9356

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 13117

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 16415

What is differnce between Error code and Error Level in Bteq

IBM,

6 39100

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 21117

What is the default join strategy in Teradata???

IBM,

5 25192

Post New Teradata Questions

Un-Answered Questions { Teradata }

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

4503

What is spool space? Why do you get spool space errors?

964

Highlight a few of the advantages that ETL tools have over Teradata.

1040

What is dimensional modeling?

1024

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

990

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

2420

Describe the between keyword in teradata?

991

Explain teradata architecture in detail with a diagram.

1059

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

780

Name the five phases that come under MultiLoad Utility.

941

Differentiate primary key and partition key?

947

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

963

Explain and compare pros and cons of start schemas?

991

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

951

Explain fallback in teradata?

991

For More Un-Answered { Teradata } Questions Click Here