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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / murali

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / varaprasad rayi

hi , is there any posiblity in parallel jobs.?

Is This Answer Correct ?    1 Yes 0 No

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

Answer / potter

readable format in the sense?

Is This Answer Correct ?    0 Yes 0 No

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

Answer / nish

what he means is the default to decimal formatting option.

so that it doesnt display the default double data with many digits after decimal

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

How to add zero "0" before record in a field?

4 Answers  

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

What is staging variable?

0 Answers  

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

What is active and passive stage?

0 Answers  

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,

Differentiate between hash file and sequential file?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories