Answer Posted / shahid

select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1505

---

Explain various types of locks in a transaction? Which is better and why?

979

---

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1997

---

What is database server and how it works?

981

---

Display the employees whose salary is less than average salary.

1012

---

WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

2202

---

What is the difference between oracle and MS Access?

1021

---

What are the various ways to execute a query in teradata?

2545

---

Why do we need distributed database?

940

---

Explain the field term used in database.

921

---

What do you mean by database?

1027

---

Is storing images in a database a good idea?

946

---

How many indexes can be created on a table?

1077

---

What is a database call?

973

---

Can you tell any two advantages of stored procedures?

992

---