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
- 9677 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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Why do we use link partitioner and link collector in datastage?
how to write server Routine coding?
How one source columns or rows to be loaded in to two different tables?
Could anyone give brief explanation bout datastage admin
What are the partitioning techniques available in link partitioner?
Differentiate between datastage and datastage tx?
Does datastage support slowly changing dimensions ?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the use of hoursfromtime() function in transformer stage in datastage?
How can you write parallel routines in datastage PX?
What are the different types of lookups in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Is it possible to query a hash file?
how to abort the job its matain duplicates?
