my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno ro

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

Question Posted / ravik.datastage

4 Answers
8246 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected..

Answer / farzana kalluri

Take source--->copy.from copy take 3 links for 3
aggregators and then filter from filter take 3 links for 3
targets..In filter mention deptno...
1.key=deptno=10
In agg column for calculation=sal
options: max(sal)
2.key=deptno=20
column for calculation=sal
options:min(sal)
3.key=deptno=30
column for calculation=sal
options:mean(sal)

Is This Answer Correct ?

6 Yes

0 No

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected..

Answer / 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

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected..

Answer / percy

use aggregator stage in that perform first keycolumn as 10
and give calculation for sal as min sal
next take as 20 as key column maxsal for calculation same
as 30th dept

Is This Answer Correct ?

1 Yes

2 No

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected..

Answer / varaprasad

hi preti,
dot post wrong answers, so many were depending on allinterviews so , if you correct then post it
so
seq---->agg --->filter deptno=10---targer ,
.....20
.....30
good luck ,
vara

Is This Answer Correct ?

0 Yes

1 No

Post New Answer