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
- 9261 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 is ds designer?
Notification Activity
What is the difference between server job and parallel jobs?
What are data elements?
Can you explain players in datastage?
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?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the repository tables in datastage?
How many types of hash files are there?
Define Routines and their types?
How a server job can be converted to a parallel job?
How to implement complex jobs in data stage?
What is difference between server jobs & parallel jobs?
What is a folder? Difference types of stages?
