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
Answer Posted / 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 |
Post New Answer View All Answers
What are the main features of datastage?
Is possible to create skid in dim,fact tables?
To see hidden files in LINIX?
What is orabulk stage?
What is aggtorec restructure operator?
What is the purpose of pivot stage and types of containers in datastage
Can you define merge?
Differentiate between data file and descriptor file?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the roundrobin collector?
Explain the importance of surrogate key in data warehousing?
What is the difference between passive stage and active stage?
How and where you used hash file?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is datastage?