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
- 10027 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sid
source->aggregate(with group key-ID,Avg(salary))-->Target
| Is This Answer Correct ? | 5 Yes | 1 No |
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 |
Answer / ramakrishna
SRC-aggregator-tgt
In the aggregator take the avg
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sai
source -> Transforemer(add column and give value 1) ->
copy -> aggregate (take sum)
->Join -> tx -> target
| Is This Answer Correct ? | 1 Yes | 5 No |
Pls tell me what is troubleshooting in datastage view?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
What is apt_config in datastage?
what is the difference between the join and look up explin me one exmple
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is difference between 8.1 , 8.5 and 9.1 ?
how to abort the job its matain duplicates?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
What are the functionalities of link partitioner?
what r the stages mostly used in realtime scenarios
how to sort two columns in single job in datastage.
Teradata 
