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
- 10153 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
How complex jobs are implemented in datstage to improve performance?
how to delete one row in target dataset
What are the different types of lookups in datastage?
root tree will find which is server job and which is parallel job?
What is size of a transaction and an array means in a datastage?
How rejected rows are managed in datastage?
Can you explain link buffering?
What is the difference between in process and inter process?
AGGREGATOR default datatype
What are transforms and what is the differenece between routines and transforms?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Can we use target hash file as a lookup ?
What are iconv and oconv?
On which Dimension Table you implemented SCD Type in your Project
