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
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 are the functionalities of link partitioner and link collector?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are some prerequisites for datastage?
What are the processing stages?
Difference between server jobs & parallel jobs?
Define Routines and their types?
EXPLAIN SCD
How do you generate sequence number in datastage?
What is a quality stage in datastage tool?
Differentiate between datastage and datastage tx?
What is a ds designer?
Differentiate between validated and Compiled in the Datastage?
Nls stands for what in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What steps should be taken to improve Datastage jobs?