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
- 10107 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
What are orabulk and bcp stages?
describe the Steps to confiure a Qlogic switch
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define Routines and their types?
what are the devoleper roles in real time? plz tell i am new to datastage....
options available in sequence job to run,validate?
What are the different options associated with dsjob command?
Differentiate between operational datastage (ods) and data warehouse?
How a source file is populated?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can you explain tagbatch restructure operator?
What could be a data source system?
Define Job control?
What are the difference types of stages?
What are routines in datastage?
