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 are the areas of application?

907


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4841


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2184


What are the functionalities of link collector?

845


What are the different type of jobs in datastage?

838


What is the differentiate between data file and descriptor file?

1113


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2642


What is apt_config in datastage?

918


What are the steps required to kill the job in Datastage?

947


What are transforms and what is the differenece between routines and transforms?

837


Lookup constraints

1037


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

860


Why fact table is in normal form?

900


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3522


Explain Quality stage?

906