Answer / prasad

select empno,sal,deptno from tablename where (sal,deptno)in(select max(sal),deptno from tablename group by deptno)



in datastage

oracle stage->aggregator stage->lookup->dataset

Answer / srinu

i writing query to in the user defined query we get answer
this is extension to first answer.......

Answer / xxx

Hi,

In Aggregator stage:

Specify Group By condition on EMPNO column instead of
DEPTNO.
aggregator type=calculation
column for calculation=sal
max value output column=max(sal)

What is oci?

0 Answers  

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

---

How a routine is called in datastage job?

0 Answers  

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

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

0 Answers  

---

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

sed,awk,head

0 Answers   CTS,

---

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

---

how to abort the job its matain duplicates?

0 Answers   TCS,

---