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 11438

Why FLOAD does not support multiset tables??

TCS, Tesco,

3 13885

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

TCS,

3 12770

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

Accenture,

5 34007

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

4 15616

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 14961

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

IBM, Mphasis,

3 10540

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

Mphasis,

4 10021

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

Mphasis,

2 18750

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 9334

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 13084

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 16399

What is differnce between Error code and Error Level in Bteq

IBM,

6 39052

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 21076

What is the default join strategy in Teradata???

IBM,

5 25156

Post New Teradata Questions

Un-Answered Questions { Teradata }

What are the components provided on node?

986

What are different table types used in teradata?

981

What are the different methods ot loading a dimension table? A fact table etc?

980

How many sessions of MAX is PE capable of handling at a particular time?

1034

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

770

What are the multiload utility limitations?

1006

What is partitioned primary index (ppi)?

1000

Can you connect multiload from ab initio?

1138

Explain the meaning of Amp?

1035

What is stored procedure in teradata?

960

What are the functions of a teradata dba?

1024

How do you set the session mode parameters in bteq?

1035

What is the function of parser component in teradata?

1037

How many codd's rules are satisfied by teradata database?

1049

What is the difference between fastload and multiload? Which one is faster?

1146

For More Un-Answered { Teradata } Questions Click Here