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
- 10328 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
Define meta stage?
how to abort the job its matain duplicates?
What is the difference between odbc and drs stage?
why do u need the IOS upgradation in a FC switch
What is the purpose of pivot stage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
how many rows sorted in sort stage by default in server jobs
Can you explain players in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Define project in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
options available in sequence job to run,validate?
Differentiate between validated and Compiled in the Datastage?
