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
- 8302 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 different types of lookups in datastage?
What is the command line function to import and export the ds jobs?
Have you have ever worked in unix environment and why it is useful in datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
To see hidden files in LINIX?
What are stage variables?
Triggers,VIEW,Procedures
Define repository tables in datastage?
what is ds administrator used for?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how many rows sorted in sort stage by default in server jobs
How to clean the datastage repository?
whom do you report?
How do y read Sequential file from job control?
Explain ibm infosphere information server and highlight its main features?
