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
- 12660 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / saran
in TFM stage we are mapping i/p records to o/p
then i/p metadata appear in o/p link then go to required column o/p link write there derivation whatever we want
in TFM stage
ex--- ano,aname,amt
1,a,3000
2,b,4000
3,c,5000
column derivation write like this (amt+1000)
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
How many areas for files does datastage have?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Different ways a project can be moved to production ?...example ….export-import and Version control.
What a datastage macro?
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.
How do y read Sequential file from job control?
Why do we use exception activity in Datastage?
What is the difference between in process and inter process?
What is process model?
How rejected rows are managed in datastage?
Explain how a source file is populated?
Define meta stage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Define ds designer?
What is the use of datastage designer?
