in aggregator , how can i get the sum in readable format
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between an operational datastage and a data warehouse?
How do you schedule or monitoring the job?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Can you highlight the main features of ibm infosphere information server?
what are the errors,warnings in datastage
How to convert RGB Value to Hexadecimal values in datastage?
How to manage date conversion in Datastage?
What is the sortmerge collector?
What are the various kinds of the hash file?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How can one find bugs in job sequence?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Differentiate between odbc and drs stage?
What is ibm datastage?
What is the command line function to import and export the ds jobs?