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
- 8245 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 to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How to read multiple files using a single datastage job if files have the same metadata?
What are routines in datastage? Enlist various types of routines.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Describe the architecture of datastage?
Explain usage analysis in datastage?
Can you explain repository tables in datastage?
How can we improve the performance in datastage?
How do you register plug-ins?
What all are the different way to run a job?
What are the stages in datastage?
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 different common services in datastage?
