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...

in aggregator , how can i get the sum in readable format

Answer Posted / rajesh

In server Job:
open Aggregator properties, select output tab, select column
whatever u required to SUM, double click on Derivation
column, select the source column, and finally select the SUM
option in drop down list of Aggregate Function and click OK.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1272


How do you remove duplicate values in datastage?

1151


What are the types of hashed files in data stage

1106


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2442


describe the Steps to confiure a Qlogic switch

2383


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2374


Can you explain how could anyone drop the index before loading the data in target in datastage?

1504


in oracle target stage when we use load option and when we use upsert option?

2284


Differentiate between datastage and informatica?

1180


Difference between in process and inter process?

1226


What are stage variables and constants?

1145


How many types of sorting methods are available in datastage?

1067


What is oci?

1300


On which Dimension Table you implemented SCD Type in your Project

2025


What are the different types of lookups in datastage?

1052