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
- 9885 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
Explain datastage architecture?
What are the enhancements made in datastage 7.5 compare with 7.0?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is ds designer?
How to RD using transformer?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the functionalities of link partitioner?
What is the importance of the exception activity in datastage?
What are the main features of datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How a routine is called in datastage job?
Which warehouse using in your datawarehouse
what is the use of surogate key in datastage
Differentiate between datastage and informatica?
