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
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do you remove duplicate values in datastage?
What are the types of hashed files in data stage
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
describe the Steps to confiure a Qlogic switch
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Can you explain how could anyone drop the index before loading the data in target in datastage?
in oracle target stage when we use load option and when we use upsert option?
Differentiate between datastage and informatica?
Difference between in process and inter process?
What are stage variables and constants?
How many types of sorting methods are available in datastage?
What is oci?
On which Dimension Table you implemented SCD Type in your Project
What are the different types of lookups in datastage?