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
- 8184 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define data aggregation?
How can you write parallel routines in datastage PX?
What are the types of containers and how to create them?
what is ds administrator used for?
Which warehouse using in your datawarehouse
What is the method of removing duplicates, without the remove duplicate stage?
What are the areas of application?
Triggers,VIEW,Procedures
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Differentiate between data file and descriptor file?
Define oconv () and iconv () functions in datastage?
What is the difference between validated and compiled in the datastage?
Define Routines and their types?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
in oracle target stage when we use load option and when we use upsert option?
