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

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

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,


how will u design file watch jobs?

2 Answers  


what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,


wt is the difference between swith and filter stage

6 Answers   IBM,


where we use config file as parameter ?

1 Answers   IBM,






Which commands are used to import and export the datastage jobs?

0 Answers  


what are the types of nodes

4 Answers   HCL, TCS,


How a routine is called in datastage job?

0 Answers  


how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,


What is the sortmerge collector?

0 Answers  


How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,


convert yyyy mm dd to dd mm yyyy?

4 Answers  


Categories