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
- 7997 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 staging variable?
What is the difference between informatica and datastage?
What is the project in datastage?
What is use Array size in datastage
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the main features of datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Have you used Unstructured data?
How can we improve performance of data stage jobs?
What is job control?
Can you explain players in datastage?
How to manage date conversion in Datastage?
How do you schedule or monitoring the job?
how to sort two columns in single job in datastage.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
