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
- 8082 Views
- I also Faced
- E-Mail Answers
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 iconv and oconv?
What is the difference between an operational datastage and a data warehouse?
Can you filter data in hashed file?
Can you define merge?
What is the difference between datastage and datastage tx?
What are the steps required to kill the job in Datastage?
What are the processing stages?
What are some prerequisites for datastage?
what is the use of surogate key in datastage
Define data aggregation?
What is difference between join, merge and lookup stage?
Difference between sequential file and data set?
How to perform incremental load in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Differentiate between validated and Compiled in the Datastage?
