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
- 9470 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 different common services in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what are the errors,warnings in datastage
Explain datastage architecture?
What are the functionalities of link collector?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the types of containers?
How a routine is called in datastage job?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Difference between server jobs & parallel jobs?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
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 ?
Describe link sort?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How do you import and export the datastage jobs?
