Answer Posted / shar

the question framed wrong
it should have been
empno,dept,sal
1,10,9
1,10,8
1,10,7
2,20,7
2,20,8.5
2,20,9
3,30,4
3,30,6
then expecting an ans is correct
o/p
empno,max(sal),min(sal),deptno
1,9,7,10
2,9,7,20
3,6,4,30
---xx----

where as in the o/p of user's question
we have
empno,max(sal),min(sal),deptno
1,9,3.5,20
2,8,4.5,20
3,6,4,10
here empno=1 his max(sal)=9 from deptno 20 and min(sal)=3.5 then its deptno=? actually we r giving a correct information but client will get confused max(sal) and min(sal) r both from 20 or different departments.
-----xxx----
even though client is expecting the same output then laxmi answer is correct

Where do the datastage jobs get stored?

1150

---

How do u convert the columns to rows in datastage?

1142

---

What are the areas of application?

1092

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1225

---

What are the steps needed to create a simple basic datastage job?

1163

---

Can you explain engine tier in information server?

1063

---

Differentiate between Join, Merge and Lookup stage?

1039

---

How the ipc stage work?

1080

---

What is the sortmerge collector?

1083

---

What are the main features of datastage?

1208

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1141

---

Explain ibm infosphere information server and highlight its main features?

1037

---

How do y read Sequential file from job control?

15802

---

Describe link sort?

960

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1298

---