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
- 6930 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between operational data stage (ods) and data warehouse?
Name the third party tools that can be used in 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
How do you remove duplicate values in datastage?
What are constraints and derivations?
What is the process of killing a job in datastage?
what is the use of materialized view?
What all the types of jobs you developed?
Have you used Unstructured data?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between passive stage and active stage?
How to implement complex jobs in data stage?
How to reverse the string using unix?
What is apt_config in datastage?
