Interested to Buy Any Domain ? << Click Here >> for more details...
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null?
empid salary previoussalary
10 1000 null
20 2000 1000
30 3000 2000
40 4000 3000
- 5 Answers
- 29851 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / indu
input file-->transformer--> output file
declare stage varibales
current salary
previous salary and initialize the previous salary to null
current salary--> previous salary
previous salary->salary
in the output file derive previousalary as
previoussalary-->current salary (stage variable)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
What can we do with datastage director?
Define APT_CONFIG in Datastage?
How can one find bugs in job sequence?
What is a merge?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the differentiate between data file and descriptor file?
how to write server Routine coding?
Define repository tables in datastage?
How and where you used hash file?
Why do you need stage variables?
Can we use target hash file as a lookup ?
What is a merge in datastage?
how to abort the job its matain duplicates?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
