in aggregator , how can i get the sum in readable format
Answers were Sorted based on User's Feedback
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 |
Answer / varaprasad rayi
hi , is there any posiblity in parallel jobs.?
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Can you highlight the main features of ibm infosphere information server?
What are routines in datastage?
whats relation between configuration file and datasets?
What is quality stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the types of views in datastage director?
How did you reconcile source with target?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
What is merge stage?
Is the value of staging variable stored temporarily or permanently?
source file is having 5 records while moving into target it want to be 10 records