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
- 10098 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
What are orabulk and bcp stages?
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)
What is the difference between datastage and informatica?
Describe link sort?
How do you start developing a datastage project?
Name the different sorting methods in datastage.
What is the difference between informatica and datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are data elements?
What is staging variable?
Define Merge?
To see hidden files in LINIX?
How do y read Sequential file from job control?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
