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
- 12633 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
Define data aggregation?
What are the features of datastage flow designer?
What steps should be taken to improve Datastage jobs?
What is the difference between hashfile and sequential file?
What is the sortmerge collector?
Explain usage analysis in datastage?
how to delete one row in target dataset
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the steps required to kill the job in Datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Which warehouse using in your datawarehouse
What is the difference between odbc and drs stage?
Define Merge?
What is the flow of loading data into fact & dimensional tables?
Name the different types of Lookups in Datastage?
