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
- 8378 Views
- I also Faced
- E-Mail Answers
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 |
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
Demonstrate experience in maintaining quality process standards?
How to initialize environment variables?
how to run jon in unix back round process what is command use in runing a job?
Can you explain engine tier in information server?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
Difference in the implementation of lookup and join stages,in joining two tables?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
State the difference between an operational datastage and a data warehouse?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
wt is the difference between swith and filter stage
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
Teradata 
