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 is the use of skid in reporting?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is data partitioning?
Explain connectivity between datastage with datasources?
Differentiate between datastage and datastage tx?
What are the types of containers?
Is possible to create skid in dim,fact tables?
What is a datastage job?
How to manage date conversion in Datastage?
Define APT_CONFIG in Datastage?
What are the various kinds of containers available in datastage?
EXPLAIN SCD
How to clean the datastage repository?
whom do you report?
What are the stages in datastage?