Interested to Buy Any Domain ? << Click Here >> for more details...
i/p
1,a,1000
2,b,2000
3,c,3000
i want to get o/p as
o/p
1,a,3000
2,b,4000
3,c,5000
how it can be done on using datastage?
- 5 Answers
- 12631 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / saran
using TFM stage we can get o/p like this
in TFM stage write derivation on column level
i.e link.column+1000
| Is This Answer Correct ? | 0 Yes | 13 No |
Post New Answer View All Answers
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is job control?
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.
Enlist various types of routines in datastage.
How do you schedule or monitoring the job?
how to delete one row in target dataset
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are some prerequisites for datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is a merge in datastage?
What are the different options associated with dsjob command?
What is merge stage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Explain connectivity between datastage with datasources?
What is the importance of the exception activity in datastage?
