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

how to retrive the max(sal),deptno,empno in datastage?

Question Posted / prasad

13 Answers
24001 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / 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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain Quality stage?

1089

How do you import and export the datastage jobs?

1109

What are the features of datastage flow designer?

993

How can you write parallel routines in datastage PX?

976

What all are the different way to run a job?

1030

How do you reject records in a transformer?

1060

What are stage variables, derivations and constants?

1166

What are the repository tables in datastage?

1258

Describe the main features of datastage?

1039

What is the use of datastage designer?

1090

What is datastage?

1031

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1508

Explain datastage architecture?

1336

Describe routines in datastage? Enlist various types of routines.

954

What is the difference between datastage and informatica?

1062