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
- 8061 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
what is the use of surogate key in datastage
How to implement complex jobs in data stage?
Name the command line functions to import and export the DS jobs?
What is ds designer?
Describe the architecture of datastage?
What is a merge in datastage?
What are the functionalities of link partitioner and link collector?
If you want to use the same piece of code in different jobs, how will you achieve it?
Describe routines in datastage? Enlist various types of routines.
What is datastage?
What are the components of datastage?
What are the types of containers and how to create them?
What are the different types of lookups in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Define oconv () and iconv () functions in datastage?
