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)

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---

What are some prerequisites for datastage?

0 Answers  

---

What are the prerequisites for join stage

2 Answers  

---

Define Job control?

0 Answers  

---

Define Routines and their types?

0 Answers  

---

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers   IBM,

---

What is the difference between the local container and shared container?

0 Answers  

---

What are the types of containers and how to create them?

0 Answers  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

Why do we use exception activity in Datastage?

0 Answers  

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---