Interested to Buy Any Domain ? << Click Here >> for more details...
in aggregator , how can i get the sum in readable format
- 4 Answers
- 10205 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 are the various kinds of containers available in datastage?
Why do we use link partitioner and link collector in datastage?
How to implement complex jobs in data stage?
how many rows sorted in sort stage by default in server jobs
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the differences between datastage and informatica?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Why do we use exception activity in Datastage?
Where do the datastage jobs get stored?
Differentiate between Join, Merge and Lookup stage?
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.
Why do you need stage variables?
What is aggtorec restructure operator?
project Steps,hits, Project level HArd things,Solved methods?
Is the value of staging variable stored temporarily or permanently?
