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...
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 components of ascential data stage?
What is ds designer?
Difference between server jobs & parallel jobs?
How to RD using transformer?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the command line function to import and export the ds jobs?
Notification Activity
What are stage variables and constants?
What are the partitioning techniques available in link partitioner?
What is oci?
On which interface you will be working as a developer?
Can you explain tagbatch restructure operator?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between datastage and informatica?
What are the types of containers?