Just take... source -> aggregate stage -> target And then in aggr

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 / pankaj das, orator

5 Answers
9473 Views
I also Faced
E-Mail Answers

Answer Posted / pankaj das, orator

Just take...
source -> aggregate stage -> target

And then in aggregate stage in output tab just specify

col name groupby derivation
------- ------- ----------
id group by id
max_sal max(sal)
min_sal min(sal)
deptno deptno

Is This Answer Correct ?

1 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the importance of surrogate key in data warehousing?

1128

How to find value from a column in a dataset?

2149

How do you import and export data into datastage?

1169

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

which r the connectors used in san?

2144

Explain datastage architecture?

1336

What is a ds designer?

1024

What is the difference between datastage and informatica?

1062

Can you explain tagbatch restructure operator?

1118

Define orabulk and bcp stages?

1069

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2391

What are the difference types of stages?

1134

Explain ibm infosphere information server and highlight its main features?

1036

Terminate Activity

1233

How do you start developing a datastage project?

1059