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

Define Routines and their types?

0 Answers  


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,


Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,


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

1 Answers   Wipro,


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  






What is the difference between informatica and datastage?

0 Answers  


INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,


How can we improve the performance in datastage?

0 Answers  


sed,awk,head

0 Answers   CTS,


how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,


what is ds administrator used for?

0 Answers  


In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,


Categories