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
- 9048 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
AGGREGATOR default datatype
what is ds administrator used for?
How complex jobs are implemented in datstage to improve performance?
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
What is usage analysis in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Distinguish between informatica & datastage. Which one would you choose and why?
What are some prerequisites for datastage?
How many areas for files does datastage have?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
On which interface you will be working as a developer?
Whats difference betweeen operational data stage (ods) and data warehouse?
Can you explain kafka connector?
what is 'reconsideration error' and how can i respond to this error and how to debug this
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
