Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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


Please Help Members By Posting Answers For Below Questions

How do you generate sequence number in datastage?

1103


what is repositery?

1853


How do y read Sequential file from job control?

15975


What are the different common services in datastage?

1297


Define APT_CONFIG in Datastage?

1091


What are system variables and sequencers in datastage

1121


What are the steps required to kill the job in Datastage?

1219


How do u convert the columns to rows in datastage?

1200


how to abort the job its matain duplicates?

2578


how can we create rank using datastage?what is the meaning of rank?

8799


What all are the different way to run a job?

1097


What is the sortmerge collector?

1138


explain about citrix scheduling tool in datastage

2464


What are the types of containers?

1244


how to sort two columns in single job in datastage.

2910