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
- 9951 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sai
source -> Transforemer(add column and give value 1) ->
copy -> aggregate (take sum)
->Join -> tx -> target
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Triggers,VIEW,Procedures
How you can fix the truncated data error in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
what is the use of surogate key in datastage
What is a folder? Difference types of stages?
How to read the length of word in unix?
How do you import and export the datastage jobs?
What are the areas of application?
What are the primary usages of datastage tool?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Define oconv () and iconv () functions in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is orabulk stage?
