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 the difference between datasatge and datastage TX?

6 Answers  

---

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

---

how can u connect the client system directly at any time?

1 Answers   IBM,

---

What is ibm datastage?

0 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

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

0 Answers  

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

---

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

---

How to clean the datastage repository?

0 Answers  

---

Difference between in process and inter process?

0 Answers  

---