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
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
How to convert RGB Value to Hexadecimal values in datastage?
What are system variables and sequencers in datastage
what is the custome stage in datastage? how can we impliment that one? plz tell me
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
describe the Steps to confiure a Qlogic switch
Differentiate between validated and Compiled in the Datastage?
What is data partitioning?
What is a folder? Difference types of stages?
What are the areas of application?
What are the job parameters?
What is datastage engine?
What are the repository tables in datastage?
Why do you need stage variables?
What is the difference between server job and parallel jobs?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?