Find 2 highest sal from each dept who have completed 5 year in org

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

How can we load single row of data into teradata database. please give me the process.

3 Answers  

write lock is compatiable with which type of lock?

6 Answers   Infosys,

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  

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

5 Answers   CTS, TCS,

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

what is amp plz explanation

5 Answers   IBM,

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

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

2 Answers   Mphasis,

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

3 Answers   TCS,

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

Why Fload doesn’t support multiset table?

8 Answers