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
- 8382 Views
- I also Faced
- E-Mail Answers
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
Can you explain how could anyone drop the index before loading the data in target in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the method of removing duplicates, without the remove duplicate stage?
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
Is it possible to query a hash file?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is a merge in datastage?
What is the difference between account and directory options ?
why do u need the IOS upgradation in a FC switch
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
What is meta stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How do you generate sequence number in datastage?
describe the Steps to confiure a Qlogic switch
What are the processing stages?
