Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 5 Answers
- 9595 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
hai first use the copy stage. from that take three links.
in that first and second links are connected to aggregator
stages.
agg1-- max and min for sal group by empno...
agg2--max only group by empno...
then use lookup for agg2 and third link of copy stage...
in lookup join max{sal} to sal and get deptno...
finally, o/p links from agg1 and lookup are joined by
lookup.. join by max{sal}....
then u can get the desired o/p...
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the steps required to kill the job in Datastage?
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
How to implement complex jobs in data stage?
Define Merge?
What are stage variables, derivations and constants?
State the difference between an operational datastage and a data warehouse?
what is use of SDR function?
What is the use of hoursfromtime() function in transformer stage in datastage?
what is the use of skid in reporting?
What are the various kinds of containers available in datastage?
How can you write parallel routines in datastage PX?
How complex jobs are implemented in datstage to improve performance?
Define ds designer?
How you Implemented SCD Type 1 & Type 2 in your project?
What are the difference types of stages?
