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
- 12827 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
What is the use of hoursfromtime() function in transformer stage in datastage?
how to write server Routine coding?
What are the main features of datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Difference between server jobs & parallel jobs?
What is difference between server jobs & parallel jobs?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Define repository tables in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
how to sort two columns in single job in datastage.
Differentiate between hash file and sequential file?
How we can covert server job to a parallel job?
Is it possible to query a hash file?
What are the steps needed to create a simple basic datastage job?
What are the types of containers?
