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?
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
Nls stands for what in datastage?
root tree will find which is server job and which is parallel job?
What are the different layers in the information server architecture?
What is the difference between passive stage and active stage?
What steps should be taken to improve Datastage jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How to reverse the string using SQL?
What is the difference between orabulk and bcp stages?
How do you import and export data into datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Define repository tables in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is a folder? Difference types of stages?
What is the method of removing duplicates, without the remove duplicate stage?
What are the differences between datastage and informatica?