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
Define ds designer?
How do you generate sequence number in datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Terminate Activity
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
How we can covert server job to a parallel job?
State the difference between an operational datastage and a data warehouse?
Can you implement SCD2 using join, transformer and funnel stage?
What is ibm datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are some different alternative commands associated with "dsjob"?
Name the different sorting methods in datastage.
what is repositery?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
sed,awk,head