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
- 29664 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / indu
input file->transformer-> output file
in transformer declare stage variables as below:
current salaray
salary
previous salary
Initialize previous salary to null
current salary ---> previous salary
previous salary----> salary
In the output file derive the previous salary as
previousalary--->previous slary (stage variable)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between hashfile and sequential file?
Can you implement SCD2 using join, transformer and funnel stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Name the third party tools that can be used in datastage?
How do you import and export data into datastage?
What are the various kinds of the hash file?
CHANGE CAPTURE
how to abort the job its matain duplicates?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Define project in datastage?
how to write server Routine coding?
How will you move hashed file from one location to another location?
What is data partitioning?
How do you start developing a datastage project?
