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 |
Differentiate between odbc and drs stage?
How to remove duplicates in transformer stage? in parallel mode
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
Why we need datasets ratherthan sequential files?
What is staging variable?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
How many areas for files does datastage have?
How do you generate sequence number in datastage?
how can or from where we can get reference data in scd type2 implementation?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
what is executable in DataStage?
Is the value of staging variable stored temporarily or permanently?