Interested to Buy Any Domain ? << Click Here >> for more details...
my soure table is emp having columns sal,deptno in the
deptno 10,20,30deptno row are there expected out
put is min(sal) of 10th deptno,max(sal) of 20th
deptno,mean(sal) of 30th deptno using aggregation stage
- 4 Answers
- 8186 Views
- I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
Where=Deptno=10 min(sal)
----------------->Agg1 --------> O/p1
Where=Deptno=20 Max(sal)
Seq--->Filter----------------->Agg2 --------->O/p2
Where=Deptno=30 Mean(Sal)
----------------->Agg3 ---------->O/p3
Agg:
Agg type=Calculation
Plz correct me if am wrong...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How and where you used hash file?
Can we use target hash file as a lookup ?
What is the process of killing a job in datastage?
Demonstrate experience in maintaining quality process standards?
What are routines in datastage?
What are the various kinds of the hash file?
what is the use of materialized view?
What are the different common services in datastage?
I have a few records just I want to store data in to targets cycling way how?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
what are the devoleper roles in real time? plz tell i am new to datastage....
Explain Quality stage?
how to write server Routine coding?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Differentiate between validated and Compiled in the Datastage?
