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 hoursfromtime() function in transformer stage in datastage?
How many Key we can define in remove duplicate stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the difference between passive stage and active stage?
What steps should be taken to improve Datastage jobs?
What is job control?
What is difference between symmetric multiprocessing and massive parallel processing?
How one source columns or rows to be loaded in to two different tables?
Explain ibm infosphere information server and highlight its main features?
How many types of hash files are there?
what is flow of project?
Can you explain kafka connector?
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 you write parallel routines in datastage PX?
Define orabulk and bcp stages?