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?
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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the difference between odbc and drs stage?
Describe the main features of datastage?
Which algorithm you used for your hashfile?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Difference between data warehousing and olap?
What is the difference between datastage and datastage tx?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the use of hoursfromtime() function in transformer stage in datastage?
how to export or import the jobs in .ISX file
How many types of stage?
how many rows sorted in sort stage by default in server jobs
What is oci?
Is it possible to query a hash file?
Define data aggregation?