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 |
job locking methods? How can we unlock the job?
what is hash file
on how many columns we can perform aggregation in the Aggregator stage?
How a routine is called in datastage job?
What is a range lookup?
How do you import and export the datastage jobs?
Thanks to all people who are posting their comments...
Explain datastage architecture?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How do u convert the columns to rows in datastage?
Wat is isolation level and when do u use them?
What is the difference between hashfile and sequential file?