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
- 29617 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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Which commands are used to import and export the datastage jobs?
What is the method of removing duplicates, without the remove duplicate stage?
What are stage variables and constants?
What is the flow of loading data into fact & dimensional tables?
What is "fatal error/rdbms code 3996" error?
in oracle target stage when we use load option and when we use upsert option?
What are the difference types of stages?
Describe link sort?
explain about citrix scheduling tool in datastage
which r the connectors used in san?
Explain datastage architecture?
What a datastage macro?
What is a folder? Difference types of stages?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
