Interested to Buy Any Domain ? << Click Here >> for more details...
i have a scenario with i/p as ID,salary with values 1,1000
2,2000 and 3,4000 i need an extra column in the o/p named
amount with values 2000,4000 and NULL. how can i get it?
- 2 Answers
- 9165 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / snr
Using TRS Satge with this logic
If ID=left(salary,1) then Salary*2 else 'Null'
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What are orabulk and bcp stages?
What is ds designer?
What is difference between join, merge and lookup stage?
Does datastage support slowly changing dimensions ?
What are the different layers in the information server architecture?
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 many types of sorting methods are available in datastage?
Can you explain engine tier in information server?
Name the third party tools that can be used in datastage?
options available in sequence job to run,validate?
What are the stages in datastage?
Have you used Unstructured data?
What is ibm datastage flow designer?
Differentiate between datastage and informatica?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
