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 7478

Why FLOAD does not support multiset tables??

Tesco, TCS,

3 10294

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

TCS,

3 8604




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

Accenture,

5 24529

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

4 12384

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 9143

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

IBM, Mphasis,

3 6799

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

Mphasis,

4 6319




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

Mphasis,

2 13071

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 6346

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 9195

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 11664

What is differnce between Error code and Error Level in Bteq

IBM,

6 29288

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 13531

What is the default join strategy in Teradata???

IBM,

5 19280


Post New Teradata Questions






Un-Answered Questions { Teradata }

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

910


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1075


if collect stats but it show low confidence why?

365


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

2869


how can we analyze the locks ?

980






how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

592


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1248


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

1387


If RDBMS is halted what will you do ?

1030


what is sysdba and sysdbc ? which has high priority ?

2632


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

793


what are the day to day activities of teradata DBA ?

4365


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1013


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1071


how many modules are there in telecome domain?how to explain the architecture?

868