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
- 8083 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
Explain the situation where you have applied SCD in your project?
What are constraints and derivations?
What are the types of containers in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Lookup constraints
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is merge stage?
whom do you report?
Which algorithm you used for your hashfile?
What is the method of removing duplicates, without the remove duplicate stage?
Describe the architecture of datastage?
Difference between data warehousing and olap?
What are routines in datastage? Enlist various types of routines.
What are the different types of lookups in datastage?
Terminate Activity
