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

job locking methods? How can we unlock the job?

3 Answers   IBM,


what is hash file

2 Answers   CTS, IBM,


on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,


How a routine is called in datastage job?

0 Answers  


What is a range lookup?

2 Answers   IBM,


How do you import and export the datastage jobs?

0 Answers  


Thanks to all people who are posting their comments...

1 Answers   CTS,


Explain datastage architecture?

0 Answers  


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  


How do u convert the columns to rows in datastage?

0 Answers  


Wat is isolation level and when do u use them?

1 Answers   HP, IBM,


What is the difference between hashfile and sequential file?

0 Answers  


Categories