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 / sid
source->aggregate(with group key-ID,Avg(salary))-->Target
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain the importance of surrogate key in data warehousing?
What are the functionalities of link partitioner?
Why do we use link partitioner and link collector in datastage?
I have a few records just I want to store data in to targets cycling way how?
What are the types of jobs we have in datastage?
What are the different layers in the information server architecture?
How you can fix the truncated data error in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the partitioning techniques available in link partitioner?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the sortmerge collector?
Define project in datastage?
what is flow of project?
What are the main features of datastage?
What can we do with datastage director?