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
9596 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

What is a ds designer?

1054

What are the functionalities of link collector?

1068

How to convert RGB Value to Hexadecimal values in datastage?

3981

How you can fix the truncated data error in datastage?

1748

Can you explain how could anyone drop the index before loading the data in target in datastage?

1486

How many types of stage?

1162

Differentiate between datastage and datastage tx?

1038

What is difference between server jobs & parallel jobs?

1020

What is the difference between operational data stage (ods) and data warehouse?

1221

project Steps,hits, Project level HArd things,Solved methods?

2105

What is the importance of the exception activity in datastage?

1053

Define meta stage?

1184

What is the use of hoursfromtime() function in transformer stage in datastage?

1047

Whats difference betweeen operational data stage (ods) and data warehouse?

1100

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3102