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 / reddymkl.dwh
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 |
Post New Answer View All Answers
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How to read the length of word in unix?
How many Key we can define in remove duplicate stage?
What is a merge?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the components of ascential data stage?
Differentiate between operational datastage (ods) and data warehouse?
What is merge stage?
table actions available in oracle connector?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
To see hidden files in LINIX?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Name the command line functions to import and export the DS jobs?
what are the devoleper roles in real time? plz tell i am new to datastage....
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4