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 / 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
What are the different types of lookups in datastage?
What are the different common services in datastage?
Terminate Activity
What is a datastage job?
How a source file is populated?
explain about citrix scheduling tool in datastage
What are iconv and oconv?
What is the use of datastage director?
how to add a new records into source?
What are transforms and what is the differenece between routines and transforms?
Can you implement SCD2 using join, transformer and funnel stage?
What are the functionalities of link partitioner?
How to implement complex jobs in data stage?
What is usage analysis in datastage?
What is datastage?