1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

in aggregator , how can i get the sum in readable format

Question Posted / murali

Answers were Sorted based on User's Feedback



in aggregator , how can i get the sum in readable format..

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

in aggregator , how can i get the sum in readable format..

Answer / varaprasad rayi

hi , is there any posiblity in parallel jobs.?

Is This Answer Correct ?    1 Yes 0 No

in aggregator , how can i get the sum in readable format..

Answer / potter

readable format in the sense?

Is This Answer Correct ?    0 Yes 0 No

in aggregator , how can i get the sum in readable format..

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

Post New Answer

More Data Stage Interview Questions

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

2 Answers  

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,




file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

For more Data Stage Interview Questions Click Here
Categories