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?
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 |
Define Merge?
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
What is APT_DUMP_SCORE?
how can we extract data with out having any common column
What can we do with datastage director?
What is staging variable?
which dim, fact tables used in bank domain
DataStage Scenario based Interview Questions
What are the various kinds of the hash file?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to call routines in stages?
what is materialized view used datastage?