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
- 6975 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
Can you explain players in datastage?
How many types of hash files are there?
What is datastage?
How we can covert server job to a parallel job?
What are the enhancements made in datastage 7.5 compare with 7.0?
client know skid info?
how can we create rank using datastage?what is the meaning of rank?
What are the different options associated with dsjob command?
What is the purpose of pivot stage and types of containers in datastage
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the functionalities of link collector?
What are the types of jobs we have in datastage?
What is the difference between validated and compiled in the datastage?
What are the functionalities of link partitioner?
Name the different types of Lookups in Datastage?
