Interested to Buy Any Domain ? << Click Here >> for more details...
i have a scenario in which i/p columns areID,salary with
1,1000 2,2000 and 3,3000 i need an extra column in the o/p
named avg(salary)how can i get it?
- 4 Answers
- 10322 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sid
source->aggregate(with group key-ID,Avg(salary))-->Target
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
whom do you report?
Differentiate between hash file and sequential file?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Define meta stage?
What are some different alternative commands associated with "dsjob"?
What are routines in datastage?
What is a merge?
What are the various kinds of containers available in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is ibm datastage flow designer?
What is usage analysis in datastage?
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
How will you move hashed file from one location to another location?
What are the stages in datastage?
How to Remove Duplicate using SQL?
