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 |
Define Routines and their types?
what is diff b/w datastage 8.1,8.5,8.7?
Difference between JOIN,LOOKUP,MERGE?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the difference between informatica and datastage?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
How can we improve the performance in datastage?
sed,awk,head
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
what is ds administrator used for?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?