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
- 8082 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / rahul baheti
Input - Transfer - Output
In Transfer, apply the order by desc on ID and define two stage variable (SVC1, SVC2) put the if condition in stage variable against SVC1 (If SVC1 = NULL then setnull() else SVC1 = SVC2) and in SVC2, assian the sal.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to read the length of word in unix?
Explain the situation where you have applied SCD in your project?
what are the devoleper roles in real time? plz tell i am new to datastage....
client know skid info?
Difference between server jobs & parallel jobs?
What steps should be taken to improve Datastage jobs?
How do you import and export the datastage jobs?
What is merge stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How to find value from a column in a dataset?
How can we improve performance of data stage jobs?
How to implement complex jobs in data stage?
Differentiate between Join, Merge and Lookup stage?
On which interface you will be working as a developer?
What all are the different way to run a job?
