Answer Posted / venkates

select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)

diff b/w inter process and in process

2163

---

What is a Transformation?

1069

---

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

2442

---

What is the relationship that exists inside in E-R diagram?

1148

---

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

2079

---

Explain database partitioning. What is its importance?

1255

---

Differentiate between delete and truncate table?

1097

---

What is the concept of Virtual field?

2097

---

What is the best database software for small businesses?

983

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1901

---

What is the purpose of firebase?

1030

---

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1265

---

What are the disadvantages of views in a database?

1104

---

A design problem was given in which I was supposed to make a design for the data base for a given problem.

1155

---

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

3007

---