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?
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, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How many types of stage?
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?
what is flow of project?
how to add a new records into source?
how to export or import the jobs in .ISX file
Differentiate between validated and Compiled in the Datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are datastage sequences?
What are the various kinds of the hash file?
What are some prerequisites for datastage?
client know skid info?
How many Key we can define in remove duplicate stage?
Which warehouse using in your datawarehouse