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
- 9160 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.
Name the third party tools that can be used in datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
what is use of SDR function?
how to sort two columns in single job in datastage.
sed,awk,head
Describe the main features of datastage?
client know skid info?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are the important features of datastage?
How do you reject records in a transformer?
What are the functionalities of link collector?
What are stage variables, derivations and constants?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
