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)

Difference between data warehousing and olap?

0 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

---

What is a quality stage?

1 Answers  

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

---

What is size of a transaction and an array means in a datastage?

0 Answers  

---

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

---