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
- 8381 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
What all are the different way to run a job?
Difference between sequential file and data set?
What are the types of views in datastage director?
What are the types of containers?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Explain how a source file is populated?
what is the difference between == and eq in UNIX shell scripting?
What can we do with datastage director?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is difference between server jobs & parallel jobs?
Nls stands for what in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What are some prerequisites for datastage?
How do you import and export data into datastage?
why do u need the IOS upgradation in a FC switch
