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 |
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
tell me abt Datastage trigger?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is a quality stage in datastage tool?
what is the function in Transformer stage can act as Rank function in Oracle
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Why do we use exception activity in Datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between SQl Loader and OCI in datastage?
What is a merge?
how to export or import the jobs in .ISX file