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
- 8079 Views
- I also Faced
- E-Mail Answers
Answer Posted / varaprasad
hi preti,
dot post wrong answers, so many were depending on allinterviews so , if you correct then post it
so
seq---->agg --->filter deptno=10---targer ,
.....20
.....30
good luck ,
vara
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can we improve performance of data stage jobs?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the repository tables in datastage?
how to add a new records into source?
What is a datastage job?
Differentiate between odbc and drs stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
Explain how a source file is populated?
How do you run datastage job from the command line?
How do you register plug-ins?
How you Implemented SCD Type 1 & Type 2 in your project?
Can you explain link buffering?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is "fatal error/rdbms code 3996" error?
