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
- 9126 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
What are the areas of application?
How a routine is called in datastage job?
Explain how a source file is populated?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
What is use Array size in datastage
Define data aggregation?
How do you import and export the datastage jobs?
Give example for FACTLESS FACT TABLE in real-time scenario.
client know skid info?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
What is the use of surrogate key stage?
Teradata 
