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
- 8244 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
Distinguish between informatica & datastage. Which one would you choose and why?
Is it possible to query a hash file?
What is the difference between in process and inter process?
How we can covert server job to a parallel job?
how to add a new records into source?
Explain datastage architecture?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the differences between datastage and informatica?
EXPLAIN SCD
How to Remove Duplicate using SQL?
Define orabulk and bcp stages?
What is aggtorec restructure operator?
What are stage variables and constants?
How a source file is populated?
Which algorithm you used for your hashfile?
