source->copy->2 aggregators->join->target 1 aggregator->e

hi my source is::
empno,deptno,salary
1, 10, 3.5
2, 20, 8
2, 10, 4.5
1, 30, 5
3, 10, 6
3, 20, 4
1, 20, 9
then target should be in below form...

empno,max(salary),min(salary),deptno
1, 9, 3.5, 20
2, 8, 4.5, 20
3, 6, 4, 10
can anyone give data flow in data stage for the above
scenario....

thanks in advance...

Question Posted / lakshmi srinivas

5 Answers
9474 Views
I also Faced
E-Mail Answers

Answer Posted / lakshmi srinivas

source->copy->2 aggregators->join->target

1 aggregator->eno,max(sal),min(sal)

2 aggregator->eno,dno,max(sal)

by using max(sal) key, we can join both o/p of
aggregators,we can get that output...

Is This Answer Correct ?

13 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1834

Difference between server jobs & parallel jobs?

1016

Nls stands for what in datastage?

1145

What is datastage engine?

1122

What is ibm datastage?

919

What is the project in datastage?

1051

Is possible to create skid in dim,fact tables?

2590

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3701

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1446

What are data elements?

1107

What is the difference between datastage and datastage tx?

1010

Triggers,VIEW,Procedures

1177

What a datastage macro?

1007

Difference between sequential file and data set?

1136

What are sequencers?

1059