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
- 8303 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
SRC-aggregator-tgt
In the aggregator take the avg
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is it possible to query a hash file?
What are the different layers in the information server architecture?
What is the difference between orabulk and bcp stages?
What are system variables and sequencers in datastage
What are constraints and derivations?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is "fatal error/rdbms code 3996" error?
table actions available in oracle connector?
whom do you report?
What can we do with datastage director?
Differentiate between datastage and datastage tx?
What is datastage?
What is a datastage job?
What are the steps required to kill the job in Datastage?
Explain ibm infosphere information server and highlight its main features?
