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...
Answer Posted / eswararao
create one group using column generator and then Using Aggregator stage select max sal,min sal
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Define Merge?
What are the partitioning techniques available in link partitioner?
Define APT_CONFIG in Datastage?
How can you write parallel routines in datastage PX?
how to abort the job its matain duplicates?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is staging variable?
Explain Quality stage?
explain about citrix scheduling tool in datastage
How do you import and export the datastage jobs?
whom do you report?
What are the functionalities of link collector?
Explain datastage architecture?
What are the different type of jobs in datastage?
sed,awk,head