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
- 9678 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 is a merge?
what is the use of surogate key in datastage
How many types of sorting methods are available in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Demonstrate experience in maintaining quality process standards?
How a source file is populated?
Differentiate between hash file and sequential file?
What are the types of views in datastage director?
what is use of SDR function?
Explain connectivity between datastage with datasources?
What are constraints and derivations?
table actions available in oracle connector?
Highlight the main features of datastage?
What are some prerequisites for datastage?
how many rows sorted in sort stage by default in server jobs
