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
- 8379 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
options available in sequence job to run,validate?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How to perform incremental load in datastage?
What a datastage macro?
What are the steps required to kill the job in Datastage?
Define oconv () and iconv () functions in datastage?
Demonstrate experience in maintaining quality process standards?
What are the repository tables in datastage?
What is the use of datastage director?
What are sequencers?
Describe routines in datastage? Enlist various types of routines.
table actions available in oracle connector?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How can we improve performance of data stage jobs?
