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
- 10154 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
What are the functionalities of link partitioner and link collector?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the main differences you have observed between 7.x and 8.x version of datastage?
what are the errors,warnings in datastage
How do u convert the columns to rows in datastage?
What is the difference between Datastage 7.5 and 7.0?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are transforms and what is the differenece between routines and transforms?
How to read multiple files using a single datastage job if files have the same metadata?
Lookup constraints
What is difference between join, merge and lookup stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Define oconv () and iconv () functions in datastage?
What are the different kinds of views available in a datastage director?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
