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
- 9127 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
Give an idea of system variables.
what is flow of project?
What are the types of containers and how to create them?
What are some prerequisites for datastage?
What is the method of removing duplicates, without the remove duplicate stage?
Define ds designer?
What are some different alternative commands associated with "dsjob"?
What is aggtorec restructure operator?
Differentiate between data file and descriptor file?
What is staging variable?
what are the devoleper roles in real time? plz tell i am new to datastage....
What can we do with datastage director?
What are the types of containers?
Is it possible to query a hash file?
Highlight the main features of datastage?
