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
- 8241 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
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
What are the steps needed to create a simple basic datastage job?
I have a few records just I want to store data in to targets cycling way how?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Define Data Stage?
What is a merge?
What are the features of datastage flow designer?
project Steps,hits, Project level HArd things,Solved methods?
What is difference between symmetric multiprocessing and massive parallel processing?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the use of surogate key in datastage
What are the functionalities of link partitioner and link collector?
what is the use of materialized view?
How you Implemented SCD Type 1 & Type 2 in your project?
