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
- 29881 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
How many types of hash files are there?
What all are the different way to run a job?
What is a merge?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Describe the architecture of datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Difference between server jobs & parallel jobs?
Terminate Activity
How to manage date conversion in Datastage?
Define APT_CONFIG in Datastage?
Differentiate between hash file and sequential file?
what is flow of project?
How do you start developing a datastage project?
EXPLAIN SCD
What is ds designer?
