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
- 10106 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 is the difference between datastage and datastage tx?
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)
Can you explain how could anyone drop the index before loading the data in target in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Define repository tables in datastage?
What steps should be taken to improve Datastage jobs?
What is the project in datastage?
What is "fatal error/rdbms code 3996" error?
Explain usage analysis in datastage?
Enlist various types of routines in datastage.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What is data partitioning?
how to delete one row in target dataset
