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
- 8316 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
What is usage analysis in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the differences between datastage and informatica?
Can you explain link buffering?
Name the command line functions to import and export the DS jobs?
What is the difference between validated and compiled in the datastage?
What is size of a transaction and an array means in a datastage?
What all the types of jobs you developed?
Does datastage support slowly changing dimensions ?
What are the different plug-ins stages used in your projects?
explain about citrix scheduling tool in datastage
What could be a data source system?
What is staging variable?
What are constraints and derivations?
What is the difference between server job and parallel jobs?
