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
- 8232 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 are the features of datastage flow designer?
Can you explain engine tier in information server?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Describe stream connector?
What are the primary usages of datastage tool?
how to export or import the jobs in .ISX file
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Can you filter data in hashed file?
Differentiate between datastage and datastage tx?
What is data partitioning?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How do you run datastage job from the command line?
How many types of stage?
How a server job can be converted to a parallel job?
What is the difference between datastage and informatica?
