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
- 9950 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
SRC-aggregator-tgt
In the aggregator take the avg
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is orabulk stage?
CHANGE CAPTURE
Differentiate between datastage and informatica?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Lookup constraints
How we can covert server job to a parallel job?
Why do we use exception activity in Datastage?
Can you explain players in datastage?
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
What is oci?
What is ibm datastage flow designer?
What are transforms and what is the differenece between routines and transforms?
what are the errors,warnings in datastage
Explain the importance of surrogate key in data warehousing?
Can you define merge?
