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
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
What are the types of containers and how to create them?
how to delete one row in target dataset
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Define data aggregation?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
what is use of SDR function?
What are the types of containers?
whom do you report?
how to implement scd2 in datastage 7.5 with lookup stage
On which Dimension Table you implemented SCD Type in your Project
What are the important features of datastage?
What are the types of hashed files in data stage
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 is flow of project?
What is the use of hoursfromtime() function in transformer stage in datastage?