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?
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
How do you generate sequence number in datastage?
what is repositery?
How do y read Sequential file from job control?
What are the different common services in datastage?
Define APT_CONFIG in Datastage?
What are system variables and sequencers in datastage
What are the steps required to kill the job in Datastage?
How do u convert the columns to rows in datastage?
how to abort the job its matain duplicates?
how can we create rank using datastage?what is the meaning of rank?
What all are the different way to run a job?
What is the sortmerge collector?
explain about citrix scheduling tool in datastage
What are the types of containers?
how to sort two columns in single job in datastage.