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
- 12646 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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)
How do y read Sequential file from job control?
What is the difference between account and directory options ?
Have you used Unstructured data?
What are orabulk and bcp stages?
how to add a new records into source?
What is use Array size in datastage
Explain how a source file is populated?
What are transforms and what is the differenece between routines and transforms?
Can you implement SCD2 using join, transformer and funnel stage?
What are the steps needed to create a simple basic datastage job?
What is a folder? Difference types of stages?
What are system variables and sequencers in datastage
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the types of hashed files in data stage
