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
- 8189 Views
- I also Faced
- E-Mail Answers
Answer Posted / percy
use aggregator stage in that perform first keycolumn as 10
and give calculation for sal as min sal
next take as 20 as key column maxsal for calculation same
as 30th dept
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How a source file is populated?
How do you schedule or monitoring the job?
how to delete one row in target dataset
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How will you move hashed file from one location to another location?
How many types of views are there in a datastage director?
why do u need the IOS upgradation in a FC switch
Describe the architecture of datastage?
What are the areas of application?
What is the difference between an operational datastage and a data warehouse?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Differentiate between data file and descriptor file?
What is the difference between datastage and datastage tx?
Describe stream connector?
