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
- 10157 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 to manage date conversion in Datastage?
What are the benefits of datastage?
What are the functionalities of link collector?
State the difference between an operational datastage and a data warehouse?
What is a merge in datastage?
How to RD using transformer?
what is repositery?
How the ipc stage work?
What are the functionalities of link partitioner and link collector?
How do u convert the columns to rows in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are sequencers?
How you Implemented SCD Type 1 & Type 2 in your project?
Define project in datastage?
