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 |
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
how will u design file watch jobs?
what is the main differences between Lookup, Join and Merge stages?
wt is the difference between swith and filter stage
where we use config file as parameter ?
Which commands are used to import and export the datastage jobs?
what are the types of nodes
How a routine is called in datastage job?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
What is the sortmerge collector?
How do y read Sequential file from job control?
convert yyyy mm dd to dd mm yyyy?