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
- 9949 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sid
source->aggregate(with group key-ID,Avg(salary))-->Target
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Distinguish between informatica & datastage. Which one would you choose and why?
Define data aggregation?
How will you move hashed file from one location to another location?
What is staging variable?
What is the purpose of pivot stage?
Can you explain repository tables in datastage?
What all the types of jobs you developed?
whom do you report?
What is the different type of jobs in datastage?
What are the primary usages of datastage tool?
How many types of stage?
What is the difference between validated and compiled in the datastage?
How you can fix the truncated data error in datastage?
How to clean the datastage repository?
What are the functionalities of link partitioner?
