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
- 9046 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 have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
how to change left and right links in join stage?
what is advantages of snowflake when it is used?
Define meta stage?
How can one find bugs in job sequence?
1)Source file contains one record, I want 100 records in target file.
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
How do u call shellscript/Batch file from DS?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
What are the primary usages of datastage tool?
What is the default padding character?
Teradata 
