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 |
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the different kinds of views available in a datastage director?
Hi Vijay here For Four CPU's how many nodes will required?
How to reverse the string using unix?
what is the difference between the join and look up explin me one exmple
Differentiate between datastage and datastage tx?
Distinguish between informatica & datastage. Which one would you choose and why?
if ename='subbu' while running job the job should be abort how come?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Notification Activity
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
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?