Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10151 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
Explain entity, attribute and relationship in datastage?
In Datastage, how you can fix the truncated data error?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the method of removing duplicates, without the remove duplicate stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Explain how a source file is populated?
What are the repository tables in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
Explain connectivity between datastage with datasources?
What is difference between server jobs & parallel jobs?
Highlight the main features of datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are some prerequisites for datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
Differentiate between datastage and informatica?
