Interested to Buy Any Domain ? << Click Here >> for more details...
in aggregator , how can i get the sum in readable format
- 4 Answers
- 10336 Views
- IBM, I also Faced
- E-Mail Answers
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 flow of loading data into fact & dimensional tables?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is staging variable?
How can we improve the performance in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are some different alternative commands associated with "dsjob"?
Triggers,VIEW,Procedures
Define project in datastage?
Explain the situation where you have applied SCD in your project?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Describe link sort?
What are stage variables and constants?
What is the use of datastage director?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to write server Routine coding?
