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
- 6981 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
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is data partitioning?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Difference between sequential file and data set?
What is use Array size in datastage
How do you start developing a datastage project?
Define repository tables in datastage?
What are iconv and oconv?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
what are the errors,warnings in datastage
Does datastage support slowly changing dimensions ?
Whats difference betweeen operational data stage (ods) and data warehouse?
How can we improve performance of data stage jobs?
How a source file is populated?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
