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
- 12666 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ra
Simple.
ano,aname,amt
1,a,1000
2,b,2000
3,c,3000
column derivation write like this (amt+2000) then we will get o/p
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / hussy
Hi,
My suggestion is instead of calculating for each column.
Create a stage variable (amt+2000)----> STG1
Call this STG1 in your derivation output amount column.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / 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 |
What are the unit test cases you used in your project?
How a routine is called in datastage job?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Differentiate between operational datastage (ods) and data warehouse?
how to capture rejected data by using join stage not for lookup stage. please let me know
Can you highlight the main features of ibm infosphere information server?
what is normalization and denormalization
How to perform incremental load in datastage?
Difference between sequential file and data set?
how many rows sorted in sort stage by default in server jobs
how can we do null handling in sequential files
What is the use of hoursfromtime() function in transformer stage in datastage?
Teradata 
