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

What is quality stage?

778


How we can covert server job to a parallel job?

802


Can you define merge?

893


What are the types of jobs we have in datastage?

888


what is the custome stage in datastage? how can we impliment that one? plz tell me

2163


Could anyone give brief explanation bout datastage admin

2178


What is size of a transaction and an array means in a datastage?

1054


How to perform incremental load in datastage?

929


What are the main differences you have observed between 7.x and 8.x version of datastage?

858


In Datastage, how you can fix the truncated data error?

879


What are iconv and oconv?

1005


What are the stages in datastage?

853


what is use of SDR function?

4940


What is the purpose of pivot stage?

864


sed,awk,head

1229