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
- 9958 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 |
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
why do we need a datawarehouse when we have databases to store data?
job locking methods? How can we unlock the job?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
How you can fix the truncated data error in datastage?
Define project in datastage?
where we use column generator stage in real time scenario?
Define Merge?
how can or from where we can get reference data in scd type2 implementation?
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
Teradata 
