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
- 29873 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
What is the purpose of pivot stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What is the purpose of pivot stage and types of containers in datastage
what is ds administrator used for?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are system variables and sequencers in datastage
Have you have ever worked in unix environment and why it is useful in datastage?
Explain usage analysis in datastage?
What are the stages in datastage?
How to perform incremental load in datastage?
How can one find bugs in job sequence?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
On which interface you will be working as a developer?
How to RD using transformer?
What are the primary usages of datastage tool?
