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
- 29793 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / indu
inputfile-->transformer-->outputfile
create stage variables
current salary
previous salary(intialize this to null)
derive them as below:
current salary-->previous salary
previous salary---> salary
in the output file derive previous salary as below
previoussalary--->current salary
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How many types of views are there in a datastage director?
describe the Steps to confiure a Qlogic switch
What is a merge in datastage?
What are some different alternative commands associated with "dsjob"?
what is repositery?
How many types of stage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are data elements?
how to export or import the jobs in .ISX file
What are the functionalities of link partitioner?
What could be a data source system?
What is ds designer?
Define orabulk and bcp stages?
what is the use of skid in reporting?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
