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
Answers were Sorted based on User's Feedback
Answer / farzana kalluri
Take source--->copy.from copy take 3 links for 3
aggregators and then filter from filter take 3 links for 3
targets..In filter mention deptno...
1.key=deptno=10
In agg column for calculation=sal
options: max(sal)
2.key=deptno=20
column for calculation=sal
options:min(sal)
3.key=deptno=30
column for calculation=sal
options:mean(sal)
Is This Answer Correct ? | 6 Yes | 0 No |
Where=Deptno=10 min(sal)
----------------->Agg1 --------> O/p1
Where=Deptno=20 Max(sal)
Seq--->Filter----------------->Agg2 --------->O/p2
Where=Deptno=30 Mean(Sal)
----------------->Agg3 ---------->O/p3
Agg:
Agg type=Calculation
Plz correct me if am wrong...
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
what is 'reconsideration error' and how can i respond to this error and how to debug this
How to get max salary of an organization using data stage stages........... can any body help me plz.......
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
Describe link sort?
What is process model?
Unix command to view the data in a dataset
what is the function in Transformer stage can act as Rank function in Oracle
how can we create tables in datastage?
I have a few records all are same structures data, I want to store data in multiple targets how?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
State the difference between an operational datastage and a data warehouse?