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 usage analysis in datastage?

0 Answers  

---

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

What is aggtorec restructure operator?

0 Answers  

---

What is oci?

0 Answers  

---

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

what is materialized view used datastage?

1 Answers   HSBC,

---

How you Remove the Dataset in Unix?

5 Answers  

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---