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
- 9128 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
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
options available in sequence job to run,validate?
Describe the architecture of datastage?
what is repositery?
What are iconv and oconv?
Is possible to create skid in dim,fact tables?
What is the roundrobin collector?
Terminate Activity
Could anyone give brief explanation bout datastage admin
How do you import and export the datastage jobs?
What are the steps required to kill the job in Datastage?
How can we improve the performance in datastage?
Which commands are used to import and export the datastage jobs?
What are the features of datastage flow designer?
