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
- 9948 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / subhash
source -> Transforemer(add column DUMMY and give value 1)
==> 2links,
1st link(with 1 hard coded value) to Copy,
1,1000,1
2,2000,1
3,3000,1
2nd Link to Join,
1,1000
2,2000
3,3000
1st linkcopy -> aggregate (Group Key-->DUMMY, take avg)--
>Join
1,2000(AVG salary)
->Join --> target
1,1000,2000
2,2000,2000
3,3000,2000
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do you schedule or monitoring the job?
What is datastage engine?
How to manage date conversion in Datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the types of hashed files in data stage
What is difference between join, merge and lookup stage?
What are the components of ascential data stage?
How do y read Sequential file from job control?
What is ibm datastage flow designer?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to Remove Duplicate using SQL?
Explain datastage architecture?
How and where you used hash file?
Which warehouse using in your datawarehouse
Explain the situation where you have applied SCD in your project?
